MicroStrategy ONE

List Security Roles statement

Lists all of the current security roles.

Copy
LIST [ALL] SECURITY ROLES [FOR ([USER] "login_name" | 
 [USER] GROUP "user_group_name") [IN PROJECT "project_name"]];

where:

  • USER "login_name" is the name of the user whose security roles you want to list, of type string.

  • USER GROUP "user_group_name" is the name of the group whose security roles you want to list, of type string.

  • PROJECT "project_name" is the project for which you want to list the security roles for the user or group, of type string.

Example

Copy
LIST 
 ALL SECURITY ROLES;
Copy
LIST 
 SECURITY ROLES FOR USER "Bob Adams" IN PROJECT "MicroStrategy 
 Tutorial";

ResultSet Columns

SECURITY_ROLE_LIST: A ResultSet listing the security role.

  • NAME: The name of the security role, returned as a string.