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.