DataDirect OpenAccess SDK Help

System privileges

Save PDF

Save PDF

Command syntax

GRANT {system_priv | role,...} TO {user | role | PUBLIC,...}

REVOKE {system_priv | role,...} FROM {user | role | PUBLIC,...}

System privileges

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.