List User Group Privileges statement

Lists current privileges of a user group. This list includes privileges that are directly granted to the group, and privileges that are inherited from other groups.

LIST [ALL] PRIVILEGES FOR USER GROUP "user_group_name";

where:

USER GROUP "user_group_name" is the name of the user group for which privileges are to be listed, of type string.

Example

LIST 
 PRIVILEGES FOR USER GROUP "Managers";

ResultSet Columns

CATEGORY_NAME: The name of the category associated with the user group, returned as a string.

PRIVILEGES: A ResultSet listing the privileges assigned to a user group.

• PRIVILEGE_NAME: The name of the privilege, returned as a string.
• PRIVILEGE_ORIGIN: A ResultSet containing a list of the origins associated with the privilege.
  • ORIGIN_NAME: The name of the origin, returned as a string.
• PRIVILEGE_TOKEN: The token associated with the privilege, such as "CREATESCHEMAOBJECTS" returned as a string.