By Haoyi
MaxCompute has a powerful security system to protect data in projects. Before using MaxCompute, you should learn some basic concepts about privileges:
MaxCompute Studio is a big data integrated development environment (IDE) tool that is provided by the Alibaba Cloud MaxCompute platform and installed on the developer’s client. MaxCompute Studio provides the following functions to help you better understand and use MaxCompute permissions:
You can use the statement "show grants" to show the permissions of a project. Privilege-related statements are integrated in the Studio Editor. Users can call the live template using a shortcut (Ctrl + J for Windows, and Command + J for Mac):
In addition, MaxCompute Studio also provides graphical display of user privileges. As shown in the following figure, click "Show privileges" on the toolbar. On the displayed "Show user privileges in this MaxCompute project" dialog box, click the "search" button, and the privileges of the user in the project are displayed below:
The "json" tab shows all privileges, and the "table" tab shows the privileges of the user on the table. When you hover the mouse over the "table" tab, the privilege description is displayed:
If the task reports an exception in authentication due to lack of privileges, you can use Studio's privilege exception diagnosis to quickly find a solution. As shown in the following figure, click the "Privilege exception diagnosis" button on the toolbar. On the displayed "Permission exception diagnosis" dialog box, enter the complete authentication exception information in the upper text box, and click "OK", then possible solutions will be displayed in the lower text box:
MaxCompute provides a series of privilege statements, which have been integrated in the MaxCompute SQL Editor. Users can execute these statements using Studio for privileges operations. Specifically, user the shortcut key (Windows: Ctrl + J, Mac: Command + J) to call the live template, and then search:
In addition, smart code prompts are also supported when writing an authorization statement:
In addition to manually written authorization statements, Studio also supports graphical authorization. Click "Show privileges" on the toolbar. On the displayed "Show user privileges" dialog box, click the "grant privilege" tab and select the authorization object, then the SQL panel below displays the corresponding authorization statement synchronously. Click "execute grant command", and wait for the backend to complete.
137 posts | 19 followers
FollowJDP - November 11, 2021
Alibaba Cloud MaxCompute - January 22, 2024
Alibaba Cloud MaxCompute - November 15, 2021
Alibaba Cloud MaxCompute - September 18, 2019
Alibaba Cloud MaxCompute - April 25, 2019
Alibaba Cloud MaxCompute - September 12, 2018
137 posts | 19 followers
FollowAlibaba Cloud provides big data consulting services to help enterprises leverage advanced data technology.
Learn MoreConduct large-scale data warehousing with MaxCompute
Learn MoreAlibaba Cloud experts provide retailers with a lightweight and customized big data consulting service to help you assess your big data maturity and plan your big data journey.
Learn MoreBuild a Data Lake with Alibaba Cloud Object Storage Service (OSS) with 99.9999999999% (12 9s) availability, 99.995% SLA, and high scalability
Learn MoreMore Posts by Alibaba Cloud MaxCompute