Security routines and views

This grouping of routines and views can be used to retrieve information about security and authorities, such as roles, authorization IDs, and groups.

ADMIN_ROTATE_MASTER_KEY procedure - Change the database master key
The ADMIN_ROTATE_MASTER_KEY procedure changes the master key for an encrypted database.
AUTH_GET_INSTANCE_AUTHID - Get the instance owner authorization ID
The AUTH_GET_INSTANCE_AUTHID scalar function returns the authorization ID of the instance owner
AUTH_LIST_AUTHORITIES_FOR_AUTHID table function
The AUTH_LIST_AUTHORITIES_FOR_AUTHID table function returns all authorities held by the authorization ID, either found in the database configuration file or granted to an authorization ID directly or indirectly through a group or a role.
AUTH_LIST_GROUPS_FOR_AUTHID table function - Retrieve group membership list for a given authorization ID
The AUTH_LIST_GROUPS_FOR_AUTHID table function returns the list of groups of which the given authorization ID is a member.
AUTH_LIST_ROLES_FOR_AUTHID function - Returns the list of roles
The AUTH_LIST_ROLES_FOR_AUTHID function returns the list of roles in which the given authorization ID is a member.
AUTHORIZATIONIDS administrative view - Retrieve authorization IDs and types
The AUTHORIZATIONIDS administrative view returns a list of all the users, roles, and groups that exist in the database catalog of the currently connected server as a result of GRANT statements.
OBJECTOWNERS administrative view - Retrieve object ownership information
The OBJECTOWNERS administrative view returns all object ownership information for every authorization ID of type USER that owns an object and that is defined in the system catalogs from the currently connected database.
PRIVILEGES administrative view - Retrieve privilege information
The PRIVILEGES administrative view returns all explicit privileges for all authorization IDs defined in the system catalogs from the currently connected database. For column privileges, see the SYSCAT.COLAUTH catalog view.

Parent topic: Supported built-in SQL routines and views