List ACL Properties statement

Lists the properties of an ACL (Access Control List) for a given object (configuration, application/schema, or folder).

Copy

LIST  [ALL] PROPERTIES FOR ACL FROM (conf_object_type "conf_object_name"| (project_object_type "project_object_name"| FOLDER "folder_name") IN FOLDER "location_path" FOR PROJECT "project_name");

where:

conf_object_type is the type of configuration object, from the following list: DBINSTANCE, DBCONNECTION, DBLOGIN, SCHEDULE, USER, GROUP, EVENT.

"conf_object_name" is the name of the configuration object from which the properties are to be listed, of type string.

project_object_type is the type of application/schema object, 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.

"project_object_name" is the name of the project object from which the properties are to be listed, of type string.

FOLDER "folder_name" is the name of the folder from which the properties are to be listed, of type string.
FOLDER "location_path" is the folder path where the application/schema object or the folder is located, of type string.
PROJECT "project_name" is the name of the project where the object is located, of type string.

Example

Copy

LIST ALL PROPERTIES FOR ACL FROM FOLDER "Subtotals" IN FOLDER "\Project Objects" FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

LIST ALL PROPERTIES FOR ACL FROM FOLDER

ACCESS_RIGHTS: Access rights to the current folder, returned as a string.
CHILDREN_ACCESS_RIGHTS: Access rights to the contents of the current folder, returned as a string.
DSS_OBJECT_TYPE: The type of the folder, returned as an integer:

256: Filter
257: Custom Group
512: Template
768: Grid Report
769: Graph Report
770: SQL Report
771: Text Report
772: Data Mart Report
773: Base Report
774: Grid Graph Report
775: Non Interactive Report
776: Intelligent Cube
1024: Metric
1025: Subtotal
1026: Subtotal
1027: Predictive Metric
1028: Training metric
1536: AutoStyle
1792: Base Formula
2048: Folder
2560: Prompt
2561: Boolean prompt
2562: Long number prompt
2563: Text prompt
2564: Numeric prompt
2565: Date prompt
2566: Object prompt
2567: Elements prompt
2568: Expression prompt
2569: Expression draft prompt
2571: Big Decimal Prompt
2816: Function
3072: Attribute
3073: Role Attribute
3074: Transformation Attribute
3075: Abstract Attribute
3328: Fact
3584: System Hierarchy
3585: Hierarchy
3586: Ordered User Hierarchy
3587: Hierarchy03840: Logical Table
3841: Metadata Partition Mapping
3842: Warehouse Partition Mapping
4352: Fact Group
4864: Resolution
5376: Attribute form
5377: Form
5378: Form
5632: Schema
6144: Catalog
6400: Catalog definition
6656: Column
7168: Property Set
7424: Database Instance
7680: Database login
7936: Database connection
8192: Project
8448: Server Definition
8704: User
8705: User Group
9216: Configuration
9472: Request
9984: Search
10240: Search folder
10752: Function Package Definition
11008: Role
11009: Transformation
11264: Security role
12032: Consolidation
12288: Consolidation Element
12544: Event
12800: Schedule
13056: Schedule
13312: Link
13568: Warehouse Table
13569: Partition table
13824: Table source
14080: HTML Document
14081: Document
14336: Drill Map
14592: DBMS
14848: Security Filter

FOLDER: The path of the parent folder, returned as a string.
ID: The ID of the current folder, returned as a string.
NAME: The name of the current folder, returned as a string.
OWNER: Owner of the folder, returned as a string.
TRUSTEE_NAME: Name of the user, returned as a string.
TRUSTEE_TYPE: Name of the user group, returned as a string.

LIST ALL PROPERTIES FOR ACL FROM <PROJECT_OBJECT>

ACCESS_RIGHTS: Access rights to the current object, returned as a string.
DSS_OBJECT_TYPE: The type of the object, returned as an integer:

256: Filter
257: Custom Group
512: Template
768: Grid Report
769: Graph Report
770: SQL Report
771: Text Report
772: Data Mart Report
773: Base Report
774: Grid Graph Report
775: Non Interactive Report
776: Intelligent Cube
1024: Metric
1025: Subtotal
1026: Subtotal
1027: Predictive Metric
1028: Training metric
1536: AutoStyle
1792: Base Formula
2048: Folder
2560: Prompt
2561: Boolean prompt
2562: Long number prompt
2563: Text prompt
2564: Numeric prompt
2565: Date prompt
2566: Object prompt
2567: Elements prompt
2568: Expression prompt
2569: Expression draft prompt
2571: Big Decimal Prompt
2816: Function
3072: Attribute
3073: Role Attribute
3074: Transformation Attribute
3075: Abstract Attribute
3328: Fact
3584: System Hierarchy
3585: Hierarchy
3586: Ordered User Hierarchy
3587: Hierarchy
3840: Logical Table
3841: Metadata Partition Mapping
3842: Warehouse Partition Mapping
4352: Fact Group
4864: Resolution
5376: Attribute form
5377: Form
5378: Form
5632: Schema
6144: Catalog
6400: Catalog definition
6656: Column
7168: Property Set
7424: Database Instance
7680: Database login
7936: Database connection
8192: Project
8448: Server Definition
8704: User
8705: User Group
9216: Configuration
9472: Request
9984: Search
10240: Search folder
10752: Function Package Definition
11008: Role
11009: Transformation
11264: Security role
12032: Consolidation
12288: Consolidation Element
12544: Event
12800: Schedule
13056: Schedule
13312: Link
13568: Warehouse Table
13569: Partition table
13824: Table source
14080: HTML Document
14081: Document
14336: Drill Map
14592: DBMS
14848: Security Filter

FOLDER: The path of the parent folder, returned as a string.
ID: The ID of the current object, returned as a string.
NAME: The name of the project object, returned as a string.
OWNER: Owner of the object, returned as a string.
TRUSTEE_NAME: Name of the user, returned as a string.
TRUSTEE_TYPE: Name of the user group, returned as a string.