Oracle Database Administration: The Essential Refe

System Privileges

There are 90 distinct system privileges defined within the Oracle8 database. These values are hardcoded and are available immediately after the CREATE DATABASE command has completed. There are three types of system privileges:

• Privileges that allow you to perform some action to or in the database

• Privileges that allow you to create objects within your own schema

• Privileges that allow you to create, alter, or drop objects in any schema

For example, the CREATE TABLE system privilege allows you to create a table within your schema, while CREATE ANY TABLE allows you to create a table in any schema.