List Security Role Privileges statement

Lists current privileges of a security role.

LIST [ALL] PRIVILEGES FOR SECURITY ROLE "security_role_name";

where:

SECURITY ROLE "security_role_name" is the name of the security role for which privileges are to be listed, of type string.

Example

LIST PRIVILEGES FOR SECURITY ROLE "Architect 
 Users";

ResultSet Columns

CATEGORY_NAME: The name of the category associated with the security role.

PRIVILEGES: A ResultSet listing the privileges contained within the security role category.

• PRIVILEGE_NAME: The name of the privilege, returned as a string.

• PRIVILEGE_TOKEN: The token associated with the privilege, such as "WEBUSER". Returned as a string.