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. | |