System Privileges : System Privileges « User Privilege « Oracle PL/SQL Tutorial

A system privilege allows a user to perform certain actions within the database-such as executing DDL statements.

Commonly Used System Privileges are

System Privilege	Allows You to
CREATE SESSION	Connect to a database.
CREATE SEQUENCE	Create a sequence.
CREATE SYNONYM	Create a synonym.
CREATE TABLE	Create a table.
CREATE ANY TABLE	Create a table in any schema.
DROP TABLE	Drop a table.
DROP ANY TABLE	Drop a table from any schema.
CREATE PROCEDURE	Create a stored procedure.
EXECUTE ANY PROCEDURE	Execute a procedure in any schema.
CREATE USER	Create a user.
DROP USER	Drop a user.
CREATE VIEW	Create a view.

36.9.System Privileges
	36.9.1.	System Privileges
	36.9.2.	Granting System Privileges to a User
	36.9.3.	Use WITH ADMIN OPTION to enable a user to grant a privilege to another user
	36.9.4.	The EXECUTE ANY PROCEDURE can then be granted to another user
	36.9.5.	Grant a privilege to all users by granting to PUBLIC
	36.9.6.	Revoke system privileges from a user using REVOKE