DOCUMENTATION
Sign In

Get access to My SAS, trials, communities and more.

SAS Viya Platform System Programming Guide
 
CASL
Lua
Python
R

Access Control Action Set: Syntax

Provides actions for managing user access to resources

isAuthorizedTables Action

Shows whether access is authorized to tables.

CASL Syntax

Expand allCollapse all
accessControl.isAuthorizedTables <result=results> <status=rc> /
required parameter caslib="string",
required parameter permission="ALTERTABLE" | "CREATETABLE" | "DELETE" | "DELETESOURCE" | "DROPTABLE" | "INSERT" | "LIMITEDPROMOTE" | "MANAGEACCESS" | "READINFO" | "SELECT" | "UPDATE",
tables={"string-1" <, "string-2", ...>}
;
indicates a required parameter

Parameter Descriptions

* caslib="string"

specifies the caslib name.

* permission="ALTERTABLE" | "CREATETABLE" | "DELETE" | "DELETESOURCE" | "DROPTABLE" | "INSERT" | "LIMITEDPROMOTE" | "MANAGEACCESS" | "READINFO" | "SELECT" | "UPDATE"

specifies the permission type.

DefaultSELECT
ALTERTABLE

affects the ability to change the properties or structure of a table.

CREATETABLE

affects the ability to save (persist) a table.

DELETE

affects the ability to delete rows.

DELETESOURCE

affects the ability to delete a source table.

DROPTABLE

affects the ability to unload a table.

INSERT

affects the ability to add rows.

LIMITEDPROMOTE

affects the ability to copy a session scope table to global scope within the same caslib.

MANAGEACCESS

affects the ability to set access controls.

READINFO

affects the ability to view and traverse objects.

SELECT

affects the ability to read data values.

UPDATE

affects the ability to change data values.

tables={"string-1" <, "string-2", ...>}

specifies one or more table names.

isAuthorizedTables Action

Shows whether access is authorized to tables.

Lua Syntax

Expand allCollapse all
results, info = s:accessControl_isAuthorizedTables{
required parameter caslib="string",
required parameter permission="ALTERTABLE" | "CREATETABLE" | "DELETE" | "DELETESOURCE" | "DROPTABLE" | "INSERT" | "LIMITEDPROMOTE" | "MANAGEACCESS" | "READINFO" | "SELECT" | "UPDATE",
tables={"string-1" <, "string-2", ...>}
}
indicates a required parameter

Parameter Descriptions

* caslib="string"

specifies the caslib name.

* permission="ALTERTABLE" | "CREATETABLE" | "DELETE" | "DELETESOURCE" | "DROPTABLE" | "INSERT" | "LIMITEDPROMOTE" | "MANAGEACCESS" | "READINFO" | "SELECT" | "UPDATE"

specifies the permission type.

DefaultSELECT
ALTERTABLE

affects the ability to change the properties or structure of a table.

CREATETABLE

affects the ability to save (persist) a table.

DELETE

affects the ability to delete rows.

DELETESOURCE

affects the ability to delete a source table.

DROPTABLE

affects the ability to unload a table.

INSERT

affects the ability to add rows.

LIMITEDPROMOTE

affects the ability to copy a session scope table to global scope within the same caslib.

MANAGEACCESS

affects the ability to set access controls.

READINFO

affects the ability to view and traverse objects.

SELECT

affects the ability to read data values.

UPDATE

affects the ability to change data values.

tables={"string-1" <, "string-2", ...>}

specifies one or more table names.

isAuthorizedTables Action

Shows whether access is authorized to tables.

Python Syntax

Expand allCollapse all
results=s.accessControl.isAuthorizedTables(
required parameter caslib="string",
required parameter permission="ALTERTABLE" | "CREATETABLE" | "DELETE" | "DELETESOURCE" | "DROPTABLE" | "INSERT" | "LIMITEDPROMOTE" | "MANAGEACCESS" | "READINFO" | "SELECT" | "UPDATE",
tables=["string-1" <, "string-2", ...>]
)
indicates a required parameter

Parameter Descriptions

* caslib="string"

specifies the caslib name.

* permission="ALTERTABLE" | "CREATETABLE" | "DELETE" | "DELETESOURCE" | "DROPTABLE" | "INSERT" | "LIMITEDPROMOTE" | "MANAGEACCESS" | "READINFO" | "SELECT" | "UPDATE"

specifies the permission type.

DefaultSELECT
ALTERTABLE

affects the ability to change the properties or structure of a table.

CREATETABLE

affects the ability to save (persist) a table.

DELETE

affects the ability to delete rows.

DELETESOURCE

affects the ability to delete a source table.

DROPTABLE

affects the ability to unload a table.

INSERT

affects the ability to add rows.

LIMITEDPROMOTE

affects the ability to copy a session scope table to global scope within the same caslib.

MANAGEACCESS

affects the ability to set access controls.

READINFO

affects the ability to view and traverse objects.

SELECT

affects the ability to read data values.

UPDATE

affects the ability to change data values.

tables=["string-1" <, "string-2", ...>]

specifies one or more table names.

isAuthorizedTables Action

Shows whether access is authorized to tables.

R Syntax

Expand allCollapse all
results <– cas.accessControl.isAuthorizedTables(s,
required parameter caslib="string",
required parameter permission="ALTERTABLE" | "CREATETABLE" | "DELETE" | "DELETESOURCE" | "DROPTABLE" | "INSERT" | "LIMITEDPROMOTE" | "MANAGEACCESS" | "READINFO" | "SELECT" | "UPDATE",
tables=list("string-1" <, "string-2", ...>)
)
indicates a required parameter

Parameter Descriptions

* caslib="string"

specifies the caslib name.

* permission="ALTERTABLE" | "CREATETABLE" | "DELETE" | "DELETESOURCE" | "DROPTABLE" | "INSERT" | "LIMITEDPROMOTE" | "MANAGEACCESS" | "READINFO" | "SELECT" | "UPDATE"

specifies the permission type.

DefaultSELECT
ALTERTABLE

affects the ability to change the properties or structure of a table.

CREATETABLE

affects the ability to save (persist) a table.

DELETE

affects the ability to delete rows.

DELETESOURCE

affects the ability to delete a source table.

DROPTABLE

affects the ability to unload a table.

INSERT

affects the ability to add rows.

LIMITEDPROMOTE

affects the ability to copy a session scope table to global scope within the same caslib.

MANAGEACCESS

affects the ability to set access controls.

READINFO

affects the ability to view and traverse objects.

SELECT

affects the ability to read data values.

UPDATE

affects the ability to change data values.

tables=list("string-1" <, "string-2", ...>)

specifies one or more table names.

Last updated: November 18, 2025