This topic describes how to add a user to a project and grant permissions to the user by using ACLs.

Scenario

Jack is the administrator of the project prj1. Alice whose Alibaba Cloud account is alice@aliyun.com applies to join the project as a new member.

Alice needs to apply for permissions to view the table list, submit jobs, and create tables.

Procedure

Perform the following operations as the project administrator Jack to add Alice to the project and grant permissions to Alice:
  1. Switch to the project prj1.
    use prj1;
  2. Add the user Alice to the project prj1.
    add user aliyun$alice@aliyun.com; 
  3. Execute the GRANT statement to grant permissions to Alice.
    grant List, CreateTable, CreateInstance on project prj1 to user aliyun$alice@aliyun.com;