getTableAccess
Syntax
getTableAccess(dbUrl, table)
Arguments
dbUrl is a string indicating the database URL.
table is a string indicating the table name.
Details
Allow users to get a detailed view of users and groups with privileges of the specified DFS table.
Note: This function can only be invoked by administrators or by users with DB_OWNER or DB_MANAGE privileges of the database.
Return value: A table with the following columns:
- name: The user or group name.
- type: User or group.
-
TABLE_READ, TABLE_INSERT, TABLE_UPDATE, TABLE_DELETE: The specific privileges. The states can be ALLOW, DENY, or NONE. For more information on user access privileges, please refer to User Access Control.
Examples
User1 with the DB_OWNER privilege creates the DFS table dfs://testDB/pt with following settings
- Grants TABLE_READ privilege to user2.
- Denies TABLE_INSERT privilege to user3.
- Grants TABLE_DELETE privilege to group1.
getTableAccess
to view the permission set of
testDB.login(`user1, `123456)
getTableAccess("dfs://testDB", "pt")
name | type | TABLE_READ | TABLE_INSERT | TABLE_UPDATE | TABLE_DELETE |
---|---|---|---|---|---|
group1 | group | NONE | NONE | NONE | ALLOW |
user3 | user | NONE | DENY | NONE | NONE |
user2 | user | ALLOW | NONE | NONE | NONE |
admin | user | ALLOW | ALLOW | ALLOW | ALLOW |
Related functions: getDBAccess