SQLTablePrivileges listed in the following table return all object-level privileges applicable to the specified tables or other database objects (macro, stored procedure, view, and so forth).
Privilege Name | Purpose |
---|---|
ALTER EXTERNAL PROCEDURE | Alter external procedure |
ALTER FUNCTION | Alter function |
ANY PRIVILEGE | All default privileges |
ALTER PROCEDURE | Alter procedure |
CREATE EXTERNAL PROCEDURE | Create an external procedure |
CREATE FUNCTION | Create function |
CREATE OWNER PROCEDURE | Create owner procedure |
CREATE ROLE | Create new user role |
CRETRIG | Create trigger |
CHECKPT | Checkpoint |
CRESPROC | Create procedure |
DROP FUNCTION | Drop function |
DROPTBL | Drop table |
DROPTRIG | Drop trigger |
DROPSPROC | Drop Procedure |
DROPDB | Drop database/user |
DROPMAC | Drop macro |
DROPVW | Drop view |
EXECUTE FUNCTION | Execute function |
EXSPROC | Execute procedure |
OVERRIDE INSERT POLICY FOR CONSTRAINT | Override insert policy for constraint |
OVERRIDE UPDATE POLICY FOR CONSTRAINT | Override update policy for constraint |
OVERRIDE DELETE POLICY FOR CONSTRAINT | Override delete policy for constraint |
OVERRIDE SELECT POLICY FOR CONSTRAINT | Override select policy for constraint |
OVERRIDE DUMP OBJECT | Override dump for object |
OVERRIDE RESTORE OBJECT | Override restore for object |
REPOVRRIDE | Replication Override |
SHOW | Access column data |
STATISTICS | Make table statistics |
unknown | New privilege to the database |
and SELECT, INSERT, UPDATE, DELETE, GRANT, DUMP, EXECUTE, RESTORE, REFERENCES, and INDEX. |