Enabling User Access to SPD Server Tables

When ACL security is enabled (recommended for all sites), SPD Server grants access rights only to the owner (creator) of the SPD Server resource. Resource owners must grant permissions for the resource to other users.
Resource owners can grant access to all SPD Server users, to an ACL group, and to individual users.
The following properties are available to grant ACL permissions to server users:
READ
read or query access to the resource
WRITE
append to or update the resource
ALTER
rename, delete, or replace a resource, and add or delete indexes associated with a table
CONTROL
permission to modify the permissions of other users and groups that are associated with this resource.
SPD Server also supports row-level security.
You grant permissions to others by defining an ACL on the resource. ACLs are created with the SPDO procedure. Work with a server administrator to create ACLs and to define row-level security for your tables. For more information about SPD Server security, see Security Overview in SAS Scalable Performance Data Server: Administrator’s Guide.
Last updated: February 8, 2017