MicroStrategy ONE

List User Privileges statement

Lists current privileges of a user.

Copy 
LIST [(ALL | INHERITED | GRANTED)] PRIVILEGES FOR USER "login_name";

where:

  • ALL indicates all privileges.

  • INHERITED indicates only privileges that the user inherits from groups or security roles.

  • GRANTED indicates only privileges that are directly granted to the user.

  • USER "login_name" is the login name of the user for whom to list privileges, of type string.

Examples

Copy 
LIST 
 ALL PRIVILEGES FOR USER "smiller;
Copy 
LIST 
 INHERITED PRIVILEGES FOR USER "ryoung;
Copy 
LIST 
 GRANTED PRIVILEGES FOR USER "oneal;

ResultSet Columns

CATEGORY_NAME: The name of the category associated with the user privilege.

PRIVILEGES: A ResultSet containing a list of user privileges and related details.

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

  • PRIVILEGE_ORIGIN: A ResultSet containing a list of origins associated with the user privileges.

    • ORIGIN_NAME: The name of the origin, returned as a string.

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