Common System Privileges : System Privileges « User Previliege « Oracle PL / SQL






Common System Privileges

Privilege                  Description

CREATE SESSION             Enables a user to connect to the database instance. 


CREATE TABLE               Enables a user to create a table in his or her schema.

CREATE VIEW                Enables a user to create a view in his or her schema.

CREATE SYNONYM             Enables a user to create a private synonym in his or her schema.

CREATE PUBLIC SYNONYM      Enables a user to create a synonym in the SYS schema that can be used by 
                           any user in the database.

CREATE PROCEDURE           Enables a user to create a stored procedure or function is his or her 
                           schema.

CREATE SEQUENCE            Enables a user to create a sequence in his or her schema.

CREATE TRIGGER             Enables a user to create a trigger in his or her schema on a table in his 
                           or her schema.

CREATE USER                Enables a user to create another user in the database and specify the 
                           password and other settings at creation time.

ALTER USER                 Enables a user to modify the user information of another user in the 
                           database, including changing the user's password.

DROP ANY TABLE             Enables a user to drop any table in any schema in the database.

ALTER ANY TABLE            Enables a user to alter any table in any schema in the database.

BACKUP ANY TABLE           Enables a user to make a copy of any table in the database using the 
                           Export utility (exp).

SELECT ANY TABLE           Enables a user to issue a SELECT statement against any table 
                           in the database.

INSERT ANY TABLE           Enables a user to issue an INSERT statement against any table in 
                           the database.

UPDATE ANY TABLE           Enables a user to issue an UPDATE statement against any table in the 
                           database.

DELETE ANY TABLE           Enables a user to issue a DELETE statement against any table in the 
                           database.





           
       








Related examples in the same category

1.Grant permissions and then check the dba_col_privs table
2.Grant create related permission