Any user, except the project owner, must be added to the MaxCompute project and granted the corresponding permissions to manage data, jobs, resources, and functions in MaxCompute.  This article describes  how a project owner can add, authorize, and remove other users, including RAM sub-accounts, to MaxCompute.

If you are a project owner, we recommend that you read this article carefully. If you are a typical user, we recommend that you submit an application to the project owner to be added to the corresponding project. We recommend all users to read the subsequent sections.

All the operations mentioned in this article are executed on the console. If the OS is Linux, run ./bin/odpscmd.  If the OS is Windows, run ./bin/odpscmd.bat.

Add a User

In the following scenario, the project owner, Alice, wants to authorize another user,  therefore she must add the user to the project first. Only a user who has been added to the project can be authorized.

The command to add a user is as follows:
add user
The <username> of an Alibaba Cloud account is a valid email address registered on the official page, or  a RAM sub-account of an Alibaba Cloud account that runs the command. For example:
add user ALIYUN$;
add user RAM$ram_test_user;
Assume that the Alibaba Cloud account of Alice is When Alice runs these statements, the following results are returned by running the list users; command:

This indicates that the Alibaba Cloud account and the sub-account ram_test_user created by Alice using RAM  have been added to the project.

Add a RAM Sub-account

The two ways to add a RAM sub-account are as following:
  • By using DataWorks, for more information, see Prepare a RAM account.
  • By using MaxCompute client commands as described in this document.
    • MaxCompute only allows a primary account to add its own RAM sub-accounts to a project. RAM sub-accounts of other Alibaba Cloud accounts are not allowed.  Therefore, you do not need to specify the name of the primary account before the RAM sub-accounts when add user.  MaxCompute determines by default that the account which runs the command is the corresponding sub-account.
    • MaxCompute only recognizes the RAM account system and does not recognize the RAM permission system.  Users can add any of their RAM sub-accounts to  a MaxCompute project, but MaxCompute does not consider  the permission limits in RAM when performing permission verification of RAM sub-accounts.
    By default, MaxCompute project only recognizes Alibaba Cloud account systems. To view the supported account systems use the list  accountproviders; command. Typically, only the ALIYUN account is visible,  for example:
    odps@ ****>list accountproviders;
    Only the project owner  has permission to perform operations related to account providers.
    As shown in the preceding figure, you can only see the ALIYUN account system.  If you want to add RAM accounts support, you can run the add accountprovider  ram; as follows:
    odps@ odps_pd_inter>add accountprovider ram;

    After added successfully, the user still cannot operate MaxCompute.  The user must be granted certain permissions to operate MaxCompute within the limits of permissions.  For more information, see  Authorization.

User Authorization

After the user has been added, the project owner or project administrator must authorize the user. The user can perform the operations only after obtaining the permissions.

MaxCompute provides ACL authorization, cross-project resource sharing, and project resource protection.  The following are two common scenarios, for more information, see ACL Authorization.

Scenario 1
In the following scenario, Jack is the administrator of the project prj1.  A new project team member Alice (Alibaba Cloud account: applies to join the project prj1, and for permission to view table  lists, submit jobs, and create tables.
The admin or the owner of the project can  run the following command on the client:
 use prj1; --Open the project prj1 
add user aliyun$; --Add the user 
grant List, CreateTable, CreateInstance on project prj1 to user aliyun$; --Authorize the user
Scenario 2
In the following scenario, assume Alibaba Cloud account user  ( has been added to a project ($user_project_name), and must be granted permission to create tables, obtain table information, and run functions.
The admin or the owner  of the project  can run the following command on the client:
grant CreateTable on PROJECT $user_project_name to USER ALIYUN$;
  --Grant CreateTable permission on project “$user_project_name” to
grant Describe on Table $user_table_name to USER ALIYUN$;
   --Grant Describe permission on table “$user_table_name” to
grant Execute on Function $user_function_name to USER ALIYUN$;
   --Grant Run permission on function "$user_function_name" to

Authorize RAM Sub-account

To check accounts support, run list  accountproviders; command as follows:
odps@ ****>list accountproviders;
In this project, RAM accounts are also supported. You can add a RAM  sub-account to this project and grant Describe permission on the tables. For example:
odps@ ****>add user ram$;
OK: DisplayName=RAM$
odps@ ****>grant Describe on table src to user ram$;
After running these commands, Alice and RAM  sub-account, can logon to MaxCompute with their own AccessKeyID and AccessKeySecret,  and run desc on the table src.
  • For more information  about how to create a RAM sub-account AccessKeyID and AccessKeySecret,  see Create a RAM user.
  • For more information about how to add or remove users on MaxCompute, see the corresponding content of this article.
  • For more information about authorizing a user, see  Authorization.

Remove a User

When a user leaves the project team, Alice must remove the user from the project.  Once a user is removed from the project, the user no longer has any access permission to the project resources. 

The command to remove a user from a project is as follows:
remove user 
  • A user removed from a project immediately loses any authority to access resources of the project.
  • Before removing a user who has been assigned roles, those roles must be revoked. For more information about roles, see Role Management.
  • After a user is removed, all ACL Authorization data related to the user  is retained.  After a user is added to a project again, the ACL Authorization of this user is enabled again.
  • MaxCompute does not support complete removal of a user and all the permission data from a project.
Alice To remove corresponding users, Alice can run the following two commands:
remove user ALIYUN$;
remove user RAM$ram_test_user;
To make sure the users are removed, run the following command:

If those two accounts are no longer listed after running the command,  it indicates that the accounts have been removed from the project.

Remove a RAM Sub-account

Similarly, RAM sub-account can be removed by using the remove user command.  sub-account For example:
odps@ ****>revoke describe on table src from user ram$;
-- Revoke Alice sub-account permissions
odps@ ****>remove user ram$;
Confirm to "remove user ram$;" (yes/no)? yes
-- Remove sub-account
If you are the project owner, you can also  remove the RAM account system from the current project by remove accountprovider as follows:
odps@ ****>remove accountprovider ram;
Confirm to "remove accountprovider ram;" (yes/no)? yes
odps@ ****>list accountproviders;