MicroStrategy - Command Manager - Privileges
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";
page revision: 2, last edited: 06 Feb 2016 00:27