Modify Generic Column ACL
This modifies generic column ACL, MINE*.SALARY, to add explicit READ and WRITE
access for a given user.
modify acl mine.salary/generic
debby=(y,y,n,n);
Modify ACL for a Catalog
This modifies catalog MYCAT to remove universal READ and group WRITE access.
set acltype catalog;
modify acl mycat/noread nogroupwrite;
Modify Generic ACL for Catalog Entries
This modifies a generic ACL for catalog entries, MYCAT.MY*.CATAMS, to remove
universal READ access.
set acltype catalog;
modify acl my
c=mycat
t=catams/generic noread;
LIST ACL and LIST ACL _ALL_
LIST ACL acl1 acl2... [/options];
LIST ACL _ALL_ [/options];
Lists information about specific ACLs acl1 acl2... where ACL entries acl1 acl2... can be
one-part resource names or two-part (table.column) names. Specifying _ALL_ lists all
existing resource ACLs for which you have control access. Specifying _ALL_ as the table
identifier in a two-part name lists all tables for which the given column is matched.
Specifying _ALL_ as the column identifier in a two-part name lists all columns for which
the given table is matched.
List ACL Options:
GENERIC
Specifies that acl1 acl2 are generic ACLs.
LIBNAME
Identifies the special LIBNAME domain ACL.
C=cat
Identifies the selected ACLs as names of catalog entries from the catalog cat. This value
must be paired with the T= option.
T=type
Identifies the catalog entry type used to qualify the selected ACLs when the C=cat
option is specified.
VERBOSE
Performs the requested table ACL listing, followed by the column ACLs for a specified
table(s). This is equivalent to a LIST ACL table followed by a LIST ACL table._ALL_.
162
Chapter 14 • ACL Security Overview
Summary of Contents for Scalable Performance Data Server 4.5
Page 1: ...SAS Scalable Performance Data Server 4 5 Administrator s Guide...
Page 7: ...Part 1 Product Notes Chapter 1 SPD Server 4 5 Product Notes 3 1...
Page 8: ...2...
Page 12: ...6...
Page 63: ...Part 3 Migration Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility 59 57...
Page 64: ...58...
Page 70: ...64 Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility...
Page 72: ...66...
Page 76: ...70 Chapter 6 Using the SPD Server Name Server to Manage Resources...
Page 94: ...88 Chapter 7 Administering and Configuring SPD Server Using the SAS Management Console...
Page 98: ...92 Chapter 8 SPD Server SQL Query Rewrite Facility...
Page 116: ...110 Chapter 10 Configuring Disk Storage for SPD Server...
Page 128: ...122 Chapter 11 Setting Up SPD Server Parameter Files...
Page 154: ...148...
Page 198: ...192 Chapter 14 ACL Security Overview...
Page 212: ...206 Chapter 15 Managing SPD Server Passwords Users and Table ACLs...
Page 214: ...208...
Page 224: ...218 Chapter 16 SPD Server Operator Interface Procedure PROC SPDO...
Page 236: ...230 Chapter 18 SPD Server Table List Utility Spdsls...
Page 256: ...250 Chapter 19 SPD Server Backup and Restore Utilities...
Page 264: ...258 Chapter 20 SPD Server Directory Cleanup Utility...
Page 270: ......