Managing object privileges

Object privileges determine the ability to perform operations on database objects:

Object	Privilege
Tablespace	USE – allows the users to create tables and indexes in the table space.
Schema	CREATEIN – allows the users to create objects within the schema. ALTERIN – allows the users to alter objects within the schema. DROPIN – allows the users to drop any object within the schema.
Table	CONTROL – provides a user with with all table privileges. Also provides the user the ability to grant or revoke more privileges on the table, excluding CONTROL. ALTER – allows a user to alter a table. SELECT – allows a user to issue SELECT statements against the table. INSERT – allows a user to issue INSERT statements against the table. UPDATE – allows a user to execute UPDATE statements against the table. DELETE – allows a user to execute DELETE statements against the table. INDEX – permits the creation of indexes for the table. REFERENCES – allows a user to create and drop...