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.