MicroStrategy ONE

Grant Security Role statement

Grants or assigns a security role to a user or user group.

If the security role grants a privilege that has prerequisite privileges, those prerequisite privileges are granted as well. For example, if you grant a security role that includes the Configure Group Membership privilege to a user that does not have the Create And Edit Users And Groups privilege, the Create And Edit Users And Groups privilege is automatically granted to that user.

Copy 
GRANT [SECURITY ROLE] "security_role_name" TO ([USER] "login_name1" [, ... "login_nameN"] | GROUP "user_group_name1" [.. "user_group_nameN"]) FOR [PROJECT] "project_name";

where:

  • SECURITY ROLE "security_role_name" is the name of the security role to be granted to a user or user group on a project, of type string.

  • USER "login_name1..N" are the login names of the users to whom the security role on a project is to be granted, of type string.

  • GROUP "user_group_name1..N" are the names of the user groups to which the security role on a project is to be granted, of type string.

  • PROJECT "project_name" is the name of the project in which the security filter is to be granted to a user or user group, of type string.

Example

Copy 
GRANT 
 SECURITY ROLE "Power User" TO USER "jhua01" FOR PROJECT 
 "Demo Project";