MicroStrategy - Command Manager - Privileges

mstr
Command Manager

LIST ALL PRIVILEGES FOR USER "test";
REVOKE WEBEDITNOTES, ADDNOTES, VIEWNOTES FROM GROUP "Everyone";
GRANT WEBDRILLING, WEBEXPORT, WEBOBJECTSEARCH, WEBSORT, WEBUSER, WEBADMIN TO GROUP "Everyone";

How can we use Command Manager to track down the group that a particular user is inheriting a particular privileges from?

LIST ALL PRIVILEGES FOR USER "test";

Privilege outlines:

/* NOTE: You can select the desired privileges from a list of available privileges located at the PRIVILEGES_LIST outline */
GRANT <privilege1> [, <privilege2> ...] TO ([USER] "<login_name>" | [USER] GROUP "<user_group_name>" | SECURITY ROLE "<sec_role_name>");

/* ==================================
This sample grants certain privileges to a user, group and security role.
   ==================================*/
GRANT CREATESCHEMAOBJECTS, SCHEDULEREQUEST, USEOBJECTMANAGER, USEVLDBEDITOR TO USER "Developer";
GRANT WEBDRILLING, WEBEXPORT, WEBOBJECTSEARCH, WEBSORT, WEBUSER, WEBADMIN TO GROUP "Managers";
GRANT USESERVERCACHE, USECUSTOMGROUPEDITOR, USEMETRICEDITOR TO SECURITY ROLE "Normal Users";

/* NOTE: You can select the desired privileges from a list of available privileges located at the PRIVILEGES_LIST outline */
REVOKE ([ALL] PRIVILEGES | <privilege1> [, <privilege2> ...]) FROM ([USER] "<login_name>" | [USER] GROUP "<group_name>" | SECURITY ROLE "<security_role_name>");

/* ======================================
This sample revokes certain privileges from users, group and security role.
   ======================================*/
REVOKE CREATESCHEMAOBJECTS FROM USER "Developer";
REVOKE ALL PRIVILEGES FROM GROUP "Managers";
REVOKE ALL PRIVILEGES FROM SECURITY ROLE "Normal Users";
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License