Oracle Study Notes: User Management

Source: Internet
Author: User
When using Oracle, there is a big difference from the previously used sqlserver experience. In Oracle, users are a key and delicious thing. Oracle is large

When using Oracle, there is a big difference from the previously used SQL server. in Oracle, users are a key and delicious thing. Oracle is large

When using Oracle, there is a big difference from the previously used SQL server. in Oracle, users are a key and delicious thing.

Oracle ranks the second largest among large databases. The largest database is db2 and the third database is sybase. Although it is only the second largest database, it is the largest database in the market, here we will not discuss the struggles between various large databases. Next we will talk about Oracle user management.

First, the Oracle database has two administrator users by default, namely sys and system users. Both users are administrators. But what are the differences between them? I personally think there are three main differences:

First, sys has DBA permissions and can only log on to the database through sysdba. It is the user with the highest permissions in the Oracle database. We generally become a super administrator. System also has the DBA permission, but does not have the sysdba role permission. Generally, you only need to use system to manage the database. Using sys to manage the database is actually a little useless.

Second, sys needs to log on with sysdba role permissions, while system needs to log on with sysoper role permissions. Sys has the create databese permission, or sysdba has a create database permission more than sysoper. The permission analysis will be explained later.

Third, sys can create and modify the base table and view of the data dictionary. System does not have this permission, or even the modification permission.

If it is not very clear, it is very simple, for example, sys is equivalent to the creator in the QQ group, and system is the administrator.

When creating a new user or table space, you can directly use system to create a table space. In the future, you can assign system permissions to users and change user passwords, you can also use system for management.

Now let's talk about an additional topic. If you have any friends who need it, you can challenge it: Oracle dba is divided into three major certifications: Primary certification (oca certification) and Expert certification (ocp certification ), ocm certification ). These three kinds of certification, from simple to difficult, usually few people can pass the ocm certification, the registration fee alone is more than tens of thousands, the domestic pass this certification is also one hundred people.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.