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.
Use getTableAccess to view the permission set of testDB.
login(`user1, `123456)
getTableAccess("dfs://testDB", "pt")
Output:
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