O'Reilly logo

Oracle® DBA SQL Quick Reference by Robert Cordingley, Charlie Russel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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
ClassPrivilegeApplies To
ClustersCreate ClusterA cluster in its own schema
 Create Any ClusterAny cluster in any schema
 Alter Any ClusterAny cluster in any schema
 Drop Any ClusterAny cluster in any schema
ContextsCreate Any ContextAny context namespace
 Drop Any ContextAny context ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required