System Privileges Types
CREATE TABLE
: Allows a user to create, drop, and alter tables in their own schema.
CREATE DATABASE LINK
: Allows a user to create, drop, and alter indexes in their own schema.
CREATE VIEW
: Allows a user to create, drop, and alter views in their own schema.
CREATE SEQUENCE
: Allows a user to create, drop, and alter sequences in their own schema.
CREATE PROCEDURE
: Allows a user to create, drop, and alter stored procedures, stored functions, and packages in their own schema.
CREATE SYNONYM
: Allows a user to create, drop, and alter synonyms in their own schema.
CREATE TRIGGER
: Allows a user to create, drop, and alter triggers in their own schema.
CREATE ANY TABLE
: Allows a user to create a table in someone else's schema.
ALTER ANY TABLE
: Allows a user to alter someone else's table.
DROP ANY TABLE
: Allows a user to drop someone else's table.
CREATE ANY INDEX
: Allows a user to create an index in someone else's schema.
ALTER ANY INDEX
: Allows a user to alter someone else's index.
DROP ANY INDEX
: Allows a user to drop someone else's index.
CREATE PUBLIC SYNONYM
: Allows a user to create synonyms that affect all users.
CREATE PUBLIC DATABASE LINK
: Allows a user to create a publicly accessible database link.
DROP PUBLIC DATABASE LINK
: Allows a user to drop a public database link.
DROP PUBLIC SYNONYM
: Allows a user to drop a public synonym.
CREATE TABLESPACE
: Allows a user to create a tablespace.
ALTER TABLESPACE
: Allows a user to modify a tablespace definition.
DROP TABLESPACE
: Allows a user to drop a tablespace.
CREATE ROLLBACK SEGMENT
: Allows a user to create a rollback segment.
ALTER ROLLBACK SEGMENT
: Allows a user modify a rollback segment.
ALTER DATABASE
: Allows a user to issue the ALTER DATABASE command.
ALTER SYSTEM
: Allows a user to issue the ALTER SYSTEM command.
UNLIMITED TABLESPACE
: Allows a user to use any amount of space in any tablespace.