Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

Data Permissions List

Updated on 2022-09-23 GMT+08:00

Table 1 describes the SQL statement permission matrix in DLI in terms of permissions on databases, tables, and roles.

Table 1 Permission matrix

Category

SQL statement

Permission

Description

Database

DROP DATABASE db1

The DROP_DATABASE permission of database.db1

-

CREATE TABLE tb1(...)

The CREATE_TABLE permission of database.db1

-

CREATE VIEW v1

The CREATE_VIEW permission of database.db1

-

EXPLAIN query

The EXPLAIN permission of database.db1

Depending on the permissions required by query statements.

Table

SHOW CREATE TABLE tb1

The SHOW_CREATE_TABLE permission of database.db1.tables.tb1

-

DESCRIBE [EXTENDED|FORMATTED] tb1

The DESCRIBE_TABLE permission of databases.db1.tables.tb1

-

DROP TABLE [IF EXISTS] tb1

The DROP_TABLE permission of database.db1.tables.tb1

-

SELECT * FROM tb1

The SELECT permission of database.db1.tables.tb1

-

SELECT count(*) FROM tb1

The SELECT permission of database.db1.tables.tb1

-

SELECT * FROM view1

The SELECT permission of database.db1.tables.view1

-

SELECT count(*) FROM view1

The SELECT permission of database.db1.tables.view1

-

LOAD DLI TABLE

The INSERT_INTO_TABLE permission of database.db1.tables.tb1

-

INSERT INTO TABLE

The INSERT_INTO_TABLE permission of database.db1.tables.tb1

-

INSERT OVERWRITE TABLE

The INSERT_OVERWRITE_TABLE permission of database.db1.tables.tb1

-

ALTER TABLE ADD COLUMNS

The ALTER_TABLE_ADD_COLUMNS permission of database.db1.tables.tb1

-

ALTER TABLE RENAME

The ALTER_TABLE_RENAME permission of database.db1.tables.tb1

-

ROLE&PRIVILEGE

CREATE ROLE

The CREATE_ROLE permission of db

-

DROP ROLE

The DROP_ROLE permission of db

-

SHOW ROLES

The SHOW_ROLES permission of db

-

GRANT ROLES

The GRANT_ROLE permission of db

-

REVOKE ROLES

The REVOKE_ROLE permission of db

-

GRANT PRIVILEGE

The GRANT_PRIVILEGE permission of db or table

-

REVOKE PRIVILEGE

The REVOKE_PRIVILEGE permission of db or table

-

SHOW GRANT

The SHOW_GRANT permission of db or table

-

For privilege granting or revocation on databases and tables, DLI supports the following permissions:

  • Permissions that can be assigned or revoked on databases are as follows:
    • DROP_DATABASE (Deleting a database)
    • CREATE_TABLE (Creating a table)
    • CREATE_VIEW (Creating a view)
    • EXPLAIN (Explaining a SQL statement as an execution plan)
    • CREATE_ROLE (Creating a role)
    • DROP_ROLE (Deleting a role)
    • SHOW_ROLES (Displaying a role)
    • GRANT_ROLE (Bounding a role)
    • REVOKE_ROLE (Unbinding a role)
    • DESCRIBE_TABLE (Describing a table)
    • DROP_TABLE (Deleting a table)
    • Select (Querying a table)
    • INSERT_INTO_TABLE (Inserting)
    • INSERT_OVERWRITE_TABLE (Overwriting)
    • GRANT_PRIVILEGE (Granting permissions to a database)
    • REVOKE_PRIVILEGE (Revoking permissions from a database)
    • SHOW_PRIVILEGES (Viewing the database permissions of other users)
    • ALTER_TABLE_ADD_PARTITION (Adding partitions to a partitioned table)
    • ALTER_TABLE_DROP_PARTITION (Deleting partitions from a partitioned table)
    • ALTER_TABLE_RENAME_PARTITION (Renaming table partitions)
    • ALTER_TABLE_RECOVER_PARTITION (Restoring table partitions)
    • ALTER_TABLE_SET_LOCATION (Setting the path of a partition)
    • SHOW_PARTITIONS (Displaying all partitions)
    • SHOW_CREATE_TABLE (Viewing table creation statements)
  • Permissions that can be assigned or revoked on tables are as follows:
    • DESCRIBE_TABLE (Describing a table)
    • DROP_TABLE (Deleting a table)
    • Select (Querying a table)
    • INSERT_INTO_TABLE (Inserting)
    • INSERT_OVERWRITE_TABLE (Overwriting)
    • GRANT_PRIVILEGE (Granting permissions to a table)
    • REVOKE_PRIVILEGE (Revoking permissions from a table)
    • SHOW_PRIVILEGES (Viewing the table permissions of other users)
    • ALTER_TABLE_ADD_COLUMNS (Adding a column)
    • ALTER_TABLE_RENAME (Renaming a table)
    • ALTER_TABLE_ADD_PARTITION (Adding partitions to a partitioned table)
    • ALTER_TABLE_DROP_PARTITION (Deleting partitions from a partitioned table)
    • ALTER_TABLE_RENAME_PARTITION (Renaming table partitions)
    • ALTER_TABLE_RECOVER_PARTITION (Restoring table partitions)
    • ALTER_TABLE_SET_LOCATION (Setting the path of a partition)
    • SHOW_PARTITIONS (Displaying all partitions)
    • SHOW_CREATE_TABLE (Viewing table creation statements)
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback