View the existing permissions of a user in the Oracle System

The following articles mainly show you how to correctly view the actual operation solutions for permissions of a user in Oracle. This article was found on a website with good reputation, if you are interested in the actual operations, you can click the following article.

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 the permissions of a user in the Oracle system, hoping to help you in this regard.