How to view the user permissions of the Oracle System

The following articles mainly introduce how to correctly view the actual operations of Oracle system user permissions and how to add permissions, the following is a detailed description of the actual application of the Oracle system user permission. I hope you will enjoy better results after browsing.

Check the existing permissions of a user in the Oracle System

 
 

  
  
select * from session_privs 
 
 

1 CREATE SESSION

2 UNLIMITED TABLESPACE

3 CREATE TABLE

4 CREATE CLUSTER

5 CREATE VIEW

6 CREATE SEQUENCE

7 CREATE PROCEDURE

8 CREATE TRIGGER

9 CREATE ANY DIRECTORY

10 CREATE TYPE

11 CREATE OPERATOR

12 CREATE INDEXTYPE

13 DEBUG CONNECT SESSION

How to add permissions

1. Enter the sys user, as shown in figure

 
 

  
  
SQL> conn sys/123456@10.10.1.111/orcl as sysdba 
 
 

2. add permissions to the new user conquer, as shown in figure

 
 

  
  
SQL> grant create session to conquer;  
 
 

The above content describes how to view the user permissions of the Oracle system. I hope it will help you in this regard.