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.