4.1 ACL Attribute Query

This sample illustrates the break up of the ACL attribute into multiple columns. The ACL_Trustee, ACL_Attribute, ACL_Read, ACL_Write columns all come from the value of the ACL attribute. For a complete list of all ACL columns see Section 3.5, Data Type Mappings. A value of one in a privilege column such as ACL_Read or ACL_Write indicates the privilege is granted to the indicated trustee. A value of zero indicates the trustee does not have that privilege. The O (Organization Name) attribute is the naming attribute for the Organization class.

SQL Statement

 SELECT O, ACL_Trustee, ACL_Attribute, ACL_Read, ACL_Write from Organization
 

Result Table

Table 4-1 ACL Attribute Query Result

O

ACL_Trustee

ACL_Attribute

ACL_Read

ACL_Write

org1

org1

Login Script

1

0

org1

org1

Print Job Configuration

1

0

ManyUsers

ManyUsers

Login Script

1

0

ManyUsers

ManyUsers

Print Job Configuration

1

0

FewUsers

FewUsers

Login Script

1

0

FewUsers

FewUsers

Print Job Configuration

1

0