MicroStrategy ONE

Alter Group ACE statement

Modifies an ACE (Access Control Entry) for a user group's ACL (Access Control List).

Copy 
ALTER ACE FOR GROUP "ace_group_name" (USER "user_name" | GROUP "group_name") [ACCESSRIGHTS 
 (VIEW | MODIFY | FULLCONTROL | DENIEDALL | DEFAULT | CUSTOM [GRANTgrant_accessright1 [, 
 ... grant_accessrightN]] 
 [DENY deny_accessright1 [, 
 ... deny_accessrightN]]) 
 DEFAULT default_accessright1 [, 
 ... default_accessrightN]])] 
 [CHILDRENACCESSRIGHTS (VIEW | MODIFY | FULLCONTROL | DENIEDALL | DEFAULT 
 | CUSTOM [GRANT grant_accessright1 [, 
 ... grant_accessrightN]] 
 [DENY deny_accessright1 [, 
 ... deny_accessrightN]] 
 DEFAULT default_accessright1  [, 
 ... default_accessrightN]])];

where:

  • GROUP "ace_group_name" is the name of the group for which an ACE is to be modified, of type string.

  • USER "user_name" is the login name of the user to be assigned to the new ACE, of type string.

  • GROUP "group_name" is the login name of the group to be assigned to the new ACE, of type string.

  • ACCESSRIGHTS indicates what access rights to grant or deny:

    • VIEW grants View rights: BROWSE, READ, USE, EXECUTE.

    • MODIFY grants Modify rights: BROWSE, READ,WRITE, DELETE, USE, EXECUTE.

    • FULLCONTROL grants all rights.

    • DENIEDALL explicitly denies all rights.

    • DEFAULT neither grants nor denies rights; all rights are inherited from groups.

    • CUSTOM allows you to specify which rights are granted and denied:

      • GRANT grant_accessright1..N is the access right (or list of access rights) to be granted to/from the ACE, from the following list: BROWSE, READ, WRITE, DELETE, CONTROL, USE, EXECUTE.

      • DENY deny_accessright1..N is the access right (or list of access rights) to be denied to/from the ACE, from the following list: BROWSE, READ, WRITE, DELETE, CONTROL, USE, EXECUTE.

      • DEFAULT default_accessright1..N is the access right (or list of access rights) in the ACE to be inherited, from the following list: BROWSE, READ, WRITE, DELETE, CONTROL, USE, EXECUTE.

  • CHILDRENACCESSRIGHTS indicates what access rights to grant or deny to this group's children, as for ACCESSRIGHTS.

Example

Copy 
ALTER ACE FOR GROUP "Managers" USER "PChang" 
 ACCESSRIGHTS FULLCONTROL CHILDRENACCESSRIGHTS MODIFY;