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.