MicroStrategy ONE

Revoke Privilege statement

Revokes a privilege from a user, user group, or security role. For a list of privilege keywords, see List of privilege tokens.

If you revoke a privilege that other privileges have as a prerequisite privilege, those privileges are revoked as well. For example, if you revoke the Create And Edit Users And Groups privilege from a user who has the Configure Group Membership privilege, the Configure Group Membership privilege is automatically revoked from that user as well.

Copy 
REVOKE 
 ([ALL] PRIVILEGES |privilege1 [, 
 ...privilegeN]]) FROM ([USER] "login_name" | 
 [USER] GROUP "user_group_name" | 
 SECURITY ROLE "security_role_name");

where:

  • ALL PRIVILEGES indicates that all privileges should be revoked from the user or group.

  • privilege1..N is a privilege from the privilege list.

  • USER "login_name" is the login name of the user for whom the privilege (or set of privileges) is to be revoked, of type string.

  • USER GROUP "user_group_name" is the name of the user group for which the privilege (or set of privileges) is to be revoked, of type string.

  • SECURITY ROLE "security_role_name" is the name of the security role for which the privilege (or set of privileges) is to be revoked, of type string.

Examples

Copy 
REVOKE 
 CREATEDATAMARTOBJECTS, CREATESCHEMAOBJECTS FROM USER "palcazar";
        
Copy 
REVOKE 
 ALL PRIVILEGES FROM GROUP "Managers";