MicroStrategy ONE

Add Project Object ACE statement

Adds a new ACE (Access Control Entry) to a project object's ACL (Access Control List).

Copy 
ADD ACE FORproject_object_type "object_name" IN 
 FOLDER "location_path" (USER "user_name" | GROUP "group_name") ACCESSRIGHTS 
 (VIEW | MODIFY | FULLCONTROL | DENIEDALL | DEFAULT | CUSTOM [GRANTgrant_accessright1 [, 
 ... grant_accessrightN]] 
 [DENY deny_accessright1 [, 
 ... deny_accessrightN]]);

where:

  • project_object_type is the type of application/schema object for which an ACE is to be added, from the following list: REPORT, DOCUMENT, PROMPT, SECFILTER, CONSOLIDATION, CUSTOMGROUP, DRILLMAP, FILTER, METRIC, SEARCH, TEMPLATE, FACT, HIERARCHY, ATTRIBUTE, FUNCTION, PARTITION, TABLE, TRANSFORMATION, SUBTOTAL, AUTOSTYLE, SHORTCUT.

    "object_name" is the name of the application/schema object, of type string.

  • FOLDER "location_path" is the folder path where the application/schema object is located, 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.

  • PROJECT "project_name" is the name of the project where the application/schema object is located, of type string.

Example

Copy 
ADD ACE FOR METRIC "Revenue" IN FOLDER 
 "\Public Objects\Metrics" USER "Developer" ACCESSRIGHTS 
 FULLCONTROL FOR PROJECT "MicroStrategy Tutorial";