Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

System Privileges

A system privilege allows a user to perform certain actions within the database-such as executing DDL statements. Commonly Used System Privileges are System PrivilegeAllows You to CREATE SESSIONConnect to a database. CREATE SEQUENCECreate a sequence. CREATE SYNONYMCreate a synonym. CREATE TABLECreate a table. CREATE ANY TABLECreate a table in any schema. DROP TABLEDrop a table. DROP ANY TABLEDrop a table from any schema. CREATE PROCEDURECreate a stored procedure. EXECUTE ANY PROCEDUREExecute a procedure in any schema. CREATE USERCreate a user. DROP USERDrop a user. CREATE VIEWCreate a view.