Oracle10g role, permission and user

 

I have some questions about Oracle10g learning. Now I want to sort out my ideas.

 

There are two parts:

 

The first part is the relationship between permissions and roles and users:

 

 

 

Permission refers to the user's permissions to access the database, such as the most basic permissions to log on to the database and add, delete, modify, and query permissions. You can connect to the database only with the create session permission. You can create a table only with the create table permission.

 

The instance code is as follows:

 

Grant create session to user_name; -- log on to the database

Grant select on scott. emp to user_name; -- allows you to query the emp table under the scott user.

 

A role is a set of Multiple permissions. It is too troublesome to assign permissions one by one when users are granted permissions. You can assign Multiple permissions to a role, then, assign the role to the user.

 

 

 

The user is the username used to log on to the database.

 

 

 

The second part is sys and system users, sysdba and sysoper system permissions:

 

Through the above sentence, we know that sys and system are users, and sysdba and sysoper are permissions.

 

Sys has a higher level than system, but both have full rights to the database, such as opening the database and closing the database. Generally, users do not have this right.

 

When plsql is used, there are three: normal, sysdba, and sysoper.

 

In fact, normal, sysdba and sysoper can also be said to be roles, but sysdba and sysoper basically belong to sys and system, and other general users use the normal role.

 

Author: tingtingego