Update Dataset ACL

Overview

This operation updates the specified NamedResource.EXECUTE and Dataset.DML CREATE, MODIFY, or DELETE permissions to the specified named tables for the specified users and roles. This operation overwrites the existing permission and sets the permissions specified in the request. The EXECUTE permission is always added if CREATE, MODIFY, or DELETE are specified.

If no permissions are specified in the request, all the permissions will be removed.

Multiple users, roles and resources can be specified in the update request.

Note: When viewed in the Spectrum Management Console, EXECUTE permissions are added to the NamedResource entity override, while the CREATE, MODIFY, and DELETE are added to the Dataset.DML entity override.

ACL Authorization Flow

The user making this request will only be able to add permission on named tables within the repository folders (or subfolders) on which they have WRITE permissions.

HTTP PUT URL Format

The following format is used for HTTP PUT requests to add dataset ACL permissions:

HTTP PUT URL:  /acl/tables/update
PUT DATA:    [
{
   "users":[
      "user1"
   ],
   "roles":[
      "role1"
   ],
   "resources":[
      "/Samples/NamedTables/WorldTable"
   ],
   "permissions":[
      "EXECUTE",
      "CREATE",
      "DELETE",
      "MODIFY"
   ]
},
{
   "users":[
      "user2"
   ],
   "roles":[
      "role2"
   ],
   "resources":[
      "/Samples/NamedTables/USA"
   ],
   "permissions":[
      "CREATE",
      "DELETE"
   ]
}
]
PUT HEADER: Content-Type:application/json

Parameters

Parameter Type Required Description
users String Yes Specifies a list of users. Required only when roles are not given in the request.
roles String Yes Specifies a list of roles. Required only when users are not given in the request.
resources String Yes Specifies a list of named tables.
permissions String No

Specifies the permission the named table needs to be given. The permission can be one or more of EXECUTE, CREATE, DELETE, or MODIFY. If no permissions are specified in the request, all the permissions will be removed.

Returns

Adds the specified NamedResource.EXECUTE and DatasetDML CREATE, MODIFY, or DELETE permissions to the specified named tables for the specified users.

Example for PUT

Request URL
http://<server>:<port>/rest/Spatial/AccessControlService/acl/tables/update

Request Body

[
{
   "users":[
      "user1"
   ],
   "roles":[
      "role1"
   ],
   "resources":[
      "/Samples/NamedTables/WorldTable"
   ],
   "permissions":[
      "EXECUTE",
      "CREATE",
      "DELETE",
      "MODIFY"
   ]
},
{
   "users":[
      "user2"
   ],
   "roles":[
      "role2"
   ],
   "resources":[
      "/Samples/NamedTables/USA"
   ],
   "permissions":[
      "CREATE",
      "DELETE"
   ]
}
]

Response

{
   
}