|
Privilege name
|
Operations permitted
|
|
INDEX
|
|
|
CREATE ANY INDEX
|
Create an index (in any schema) on any table.
|
|
ALTER ANY INDEX
|
Alter any index in the database.
|
|
DROP ANY INDEX
|
Drop any index in the database.
|
|
PRIVILEGE
|
|
|
GRANT ANY PRIVILEGE
|
Grant any system privilege (not object privilege).
|
|
PROCEDURE
|
|
|
CREATE PROCEDURE
|
Create procedure in own schema.
|
|
CREATE ANY PROCEDURE
|
Create procedure in any schema.
|
|
DROP ANY PROCEDURE
|
Drop any procedure in any schema.
|
|
EXECUTE ANY PROCEDURE
|
Execute any procedure in any schema.
|
|
ROLE
|
|
|
GRANT ANY ROLE
|
Grant any role in database.
|
|
TABLE
|
|
|
CREATE TABLE
|
Create tables in own schema.
|
|
CREATE ANY TABLE
|
Create a table in any schema.
|
|
ALTER ANY TABLE
|
Alter any table in any schema.
|
|
DROP ANY TABLE
|
Drop any table in any schema.
|
|
SELECT ANY TABLE
|
Query any object in any schema.
|
|
INSERT ANY TABLE
|
Insert rows into any object in any schema.
|
|
UPDATE ANY TABLE
|
Update rows into any object in any schema.
|
|
DELETE ANY TABLE
|
Delete rows into any object in any schema and truncate any object.
|
|
VIEW
|
When validating permissions for accessing views, only permissions on the View are checked, and not the base tables.
|
|
CREATE VIEW
|
Create a view in own schema.
|
|
CREATE ANY VIEW
|
Create a view in any schema.
|
|
DROP ANY VIEW
|
Drop any view in any schema.
|
|
USER
|
|
|
CREATE USER
|
Create a user in own schema.
|
|
CREATE ANY USER
|
Create a user in any schema.
|
|
DROP ANY USER
|
Drop any user in any schema.
|
|
ROLE
|
|
|
CREATE ROLE
|
Create a role in own schema.
|
|
CREATE ANY ROLE
|
Create a role in any schema.
|
|
DROP ANY ROLE
|
Drop any role in any schema.
|