Management of Oracle user permissions

In Oracle databases, user permissions are divided into two types (here we do not discuss dba or dbopr permissions, but only the permissions of common users ), system Privilege System permission and User Table Privilege User data Table permission.

1. First, create a user. The following commands can be used to create a user, provided that the user must Log On As a dba.
Create user DB_USER identified by DB_USER_PW: create user DB_USER with the password DB_USER_PW

Grant create session to DB_USER permission to create a session for the user

Grant resource to DB_USER

2. after a user is created, Scheme of the user is automatically generated in the Oracle database system (it can be understood as all tables belonging to the user, view .... object set ).

This user can grant access permissions to these objects to other system users.

3. After the user logs on with sqlplus, the following command shows the user's permissions.

This user's permission to read other user objects:
Select * from user_tab_privs;
System permissions of the User:
Select * from user_sys_privs;