Brief Introduction to the Oracle Database Administrator authentication method

In Oracle, user permissions are divided into two types (this article does not involve dba or role permissions, but only describes 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 you must Log On As a dba (if you are not a DBA, do not check it ):

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 a user

Grant resource to DB_USER

◆ 2. After a user is created, Scheme of the user is automatically generated in the Oracle database system (which can be understood as all tables and views of the user ...... ).

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 has the following permissions to read other user objects:

Select * from user_tab_privs;

System permissions of this user:

Select * from user_sys_privs;