Oracle® DBA SQL Quick Reference

Privileges

Oracle supports a rich selection of privileges that are assigned with the GRANT command, and removed with the REVOKE command.

System Privileges

System privileges are granted and revoked to users and roles and generally apply to an entire class or group of objects. To be able to GRANT or REVOKE a system privilege, the user must have been granted the privilege with the ADMIN OPTION, or have the GRANT ANY PRIVILEGE system privilege.

Table 1-17. System Privileges

Class	Privilege	Applies To
Clusters	Create Cluster	A cluster in its own schema
	Create Any Cluster	Any cluster in any schema
	Alter Any Cluster	Any cluster in any schema
	Drop Any Cluster	Any cluster in any schema
Contexts	Create Any Context	Any context namespace
	Drop Any Context	Any context ...