SPDO Procedure

LIST ACL Statement

Lists information about ACLs.

Requirement:	You must be the resource owner, have ACL access to a resource, or have special privilege in order to list ACLs. When using special privilege, set the ACLSPECIAL= option in the LIBNAME statement.
Interaction:	Before using LIST ACL, you must set the context for the request with the SET ACLUSER statement. For more information, see SET ACLUSER Statement.

Example 1: List All ACL Entries

Example 2: List a Generic ACL

Example 3: List All Column ACLS for a Table

Example 4: List All Column ACLs for All Tables

Example 5: List the Column ACL for a Specific Column

Example 6: List All ACL Data for a Table

Example 7: List All ACLs for Catalogs

Example 8: List All ACLs for a Catalog

Syntax

LIST ACL acl1 [acl2...] [/options];

LIST ACL _ALL _ [/options];

Optional Arguments

_ALL_

lists all existing resource ACLs for which ACLUSER has Control access.

C=cat

identifies the selected ACLs as names of catalog entries from the catalog cat. The C= option must be paired with the T= option.

/GENERIC

identifies the specified ACLs as generic ACLs.

Note	If you specify /GENERIC when listing table column ACLs, the /GENERIC applies to the table name, not to the column name. You cannot use wildcards with column names.

/LIBNAME

identifies the domain ACL.

T=type

identifies the catalog entry type used to qualify the selected ACLs when the C= option is specified.

/VERBOSE

performs the requested table ACL listing, followed by the column ACLs for a specified table or tables. This is equivalent to a LIST ACL table followed by a LIST ACL table._ALL_.

Details

Use the LIST ACL _ALL_ syntax to list all existing resource ACLs for which ACLUSER has Control access.

Use the LIST ACL acl1 [acl2] syntax to list specified ACL entries owned by ACLUSER. The ACL entries can be one-part resource names or two-part (table.column) names. Specify _ALL_ as the table identifier in a two-part name to list all tables for which the given column is matched. Specify _ALL_ as the column identifier in a two-part name to list all columns for which the given table is matched. Other optional arguments further filter the listing, except VERBOSE. The VERBOSE option expands the listing.

Examples

Example 1: List All ACL Entries

This lists all ACL entries for the current ACL type setting.

set acltype data;
list acl _all_;

Example 2: List a Generic ACL

This lists a generic ACL entry for MINE*.

list acl mine/generic;

Example 3: List All Column ACLS for a Table

This lists all column ACLs for table MINE_AUG2016.

list acl mine_aug2016._all_;

Example 4: List All Column ACLs for All Tables

This lists all column ACLs for all tables.

list acl _all._all_;

Example 5: List the Column ACL for a Specific Column

This lists the column ACL for MINE_JAN2006.SALARY.

list acl mine_jan2006.salary;

Example 6: List All ACL Data for a Table

This provides all ACL information for table MINE_AUG2016.

list acl mine_aug2016/verbose;

Example 7: List All ACLs for Catalogs

This lists all ACLs for the ACL type 'catalog'.

set acltype catalog;
list acl _all_;

Example 8: List All ACLs for a Catalog

This lists all ACLs for catalog MYCAT.?.CATAMS.

set acltype catalog;
 list acl _all_ c=mycat t=catams;

Last updated: February 3, 2017