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

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.