Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Data Permissions Management/ Deleting a Role
Updated on 2024-02-07 GMT+08:00
View PDF
Share

Deleting a Role

Function

This statement is used to delete a role in the current database or a specified database.

Syntax

1
 
DROP ROLE [db_name].role_name;

Keywords

None

Precautions

  • The role_name to be deleted must exist in the current database or the specified database. Otherwise, an error will be reported.
  • If db_name is not specified, the role is deleted in the current database.

Example

1
 
DROP ROLE role1;