LAS provides metadata object permission management functionality, enabling you to manage permissions for LAS metadata objects such as Catalog, Schema, Table, and UDF. This includes adding, displaying, editing, and deleting permissions. This document introduces the key points for permission management operations and provides a detailed permission list.
Prerequisites for granting permissions to a user or group on the LAS permission management page:
Log in and enter LAS Console. In the left navigation bar, click "Metadata" > "rights management" to enter the metadata permission management page. Click the Add authorization button in the upper right corner of the page.
Configure the permission control details in the pop-up sidebar.
Parameters | Configuration instructions |
|---|---|
Authorized resources | Select the type of authorization object and the specific authorization object.
|
authorized object | Select which user, user group, or role to authorize.
|
Grant permission | Select the scope of permissions for the role to be granted to the target user.
You can refer to the permission list to select the permission role to grant. |
The metadata at different levels corresponds to different permission points and roles, as well as their relationships. Details are as follows:
Permission point | Role | |||||||
|---|---|---|---|---|---|---|---|---|
Permission name | Description | Admin | Developer | Viewer | Create | Read | Drop | Write |
CreateTable | Permission to create tables and views within the database | ✔️ | ✔️ | ✔️ | ||||
CreateFunction | Permission to create functions within the database | ✔️ | ✔️ | ✔️ | ||||
CreateResource | Permission to create resources within the database | ✔️ | ✔️ | ✔️ | ||||
Describe | Read database metadata | ✔️ | ✔️ | ✔️ | ✔️ | |||
Select | Has Select permission on all tables within the database | ✔️ | ✔️ | ✔️ | ✔️ | |||
Insert | Has Insert permission on all tables within the database | ✔️ | ✔️ | ✔️ | ||||
Show | List all objects within the database, including tables, resources, functions, instances, and more | ✔️ | ✔️ | ✔️ | ✔️ | |||
Drop | Delete database | ✔️ | ✔️ | |||||
Alter | Modify database information | ✔️ | ✔️ | |||||
All | Includes all of the above permissions, including the permission to grant them | ✔️ | ||||||
Permission point | Role | ||||||
|---|---|---|---|---|---|---|---|
Permission name | Description | Admin | Developer | Viewer | Read | Drop | Write |
Describe | Read table metadata | ✔️ | ✔️ | ✔️ | ✔️ | ||
Select | Read table data | ✔️ | ✔️ | ✔️ | ✔️ | ||
Alter | Modify table metadata or add or delete partitions | ✔️ | ✔️ | ✔️ | |||
Insert | Write to or overwrite table data | ✔️ | ✔️ | ✔️ | |||
Drop | Delete table | ✔️ | ✔️ | ||||
All | Includes all of the above permissions, including the permission to grant them | ✔️ | |||||
Permission point | Role | |||
|---|---|---|---|---|
Permission name | Description | Admin | Developer | Viewer |
Read | Read function information | ✔️ | ✔️ | ✔️ |
Write | Update function | ✔️ | ✔️ | |
Delete | Delete function | ✔️ | ||
Execute | Permission to execute functions | ✔️ | ✔️ | ✔️ |
All | Includes all of the above permissions, including the permission to grant them | ✔️ | ||
API | Description |
|---|---|
Retrieve the list of users or user groups with permissions for the specified object | |
Query the user list | |
Grant a user permissions for a specified data object | |
Revoke a user's permissions for a specified data object | |
Modify a user's permissions for a specified object |