MicroStrategy ONE

Security role manipulation: List Security Role Members statement

Lists current users and groups who are members of a security role for a given project.

Copy
LIST ALL MEMBERS FOR SECURITY ROLE "security_role_name" IN PROJECT "project_name";

where:

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

  • PROJECT "project_name" is the project for which members of the security role are to be listed, of type string.

Example

Copy
LIST PROPERTIES FOR SECURITY ROLE "Architect 
 Users";

ResultSet Columns

MEMBER_RESULTSET: A ResultSet listing the members of the security role.

  • FULL_NAME: The full name of the user or group, returned as a string.

  • IS_GROUP: Whether the member is a user or a group, returned as a Boolean.

  • USER_OR_GROUP_NAME: The login name of the user or group, returned as a string.