The PRIVILEGES administrative view returns all explicit privileges for all authorization IDs defined in the system catalogs from the currently connected database.
The schema is SYSIBMADM.
SELECT AUTHID, PRIVILEGE, OBJECTNAME, OBJECTSCHEMA, OBJECTTYPE
FROM SYSIBMADM.PRIVILEGES
AUTHID PRIVILEGE OBJECTNAME OBJECTSCHEMA OBJECTTYPE
--------...- ----------- -------------------...- ------------...- ----------...-
JESSICAE EXECUTE SQLE0F00 NULLID PACKAGE
PUBLIC EXECUTE SYSSH201 NULLID PACKAGE
JESSICAE EXECUTE SYSSH202 NULLID PACKAGE
PUBLIC EXECUTE SYSSH202 NULLID PACKAGE
DOCTOR EXECUTE PKG0123 NULLID PACKAGE
...
PUBLIC EXECUTE SQL051109185227800 SYSPROC FUNCTION
JESSICAE EXECUTE SQL051109185227801 SYSPROC FUNCTION
PUBLIC EXECUTE SQL051109185227801 SYSPROC FUNCTION
JESSICAE EXECUTE SQL051109185227838 SYSPROC FUNCTION
PUBLIC EXECUTE SQL051109185227838 SYSPROC FUNCTION
...
PUBLIC EXECUTE LIST_SRVR_TYPES SYSPROC PROCEDURE
PUBLIC EXECUTE LIST_SRVR_VERSIONS SYSPROC PROCEDURE
PUBLIC EXECUTE LIST_WRAP_OPTIONS SYSPROC PROCEDURE
PUBLIC EXECUTE LIST_SRVR_OPTIONS SYSPROC PROCEDURE
...
SYSTEM POLICY_UNQ SYSTOOLS INDEX
PUBLIC CREATEIN NULLID SCHEMA
PUBLIC UPDATE COLUMNS SYSSTAT VIEW
PUBLIC UPDATE COLGROUPS SYSSTAT VIEW
...
Column name | Data type | Description |
---|---|---|
AUTHID | VARCHAR(128) | Authorization ID that has been explicitly granted this privilege. |
AUTHIDTYPE | CHAR(1) | Authorization ID type:
|
PRIVILEGE | VARCHAR(11) | Privilege that has been explicitly granted to this authorization ID. |
GRANTABLE | VARCHAR(1) | Indicates if the privilege is grantable:
|
OBJECTNAME | VARCHAR(128) | Database object name. |
OBJECTSCHEMA | VARCHAR(128) | Database object schema. |
OBJECTTYPE | VARCHAR(24) | Database object type. |