Using Role Management Commands

This section describes how to use basic syntax and SQL statements to manage roles.

Creating a role ( role_name indicates the name of the role to be created)
```
CREATE role IF NOT EXISTS 'role_name' ON CLUSTER default_cluster;
```
Granting permissions to a role
- Granting all creation (database and table) permissions
```
GRANT CREATE ON *.* TO role1 ON CLUSTER default_cluster;
```
- Granting the permission to create tables in the test_db database
```
GRANT CREATE TABLE ON test_db.* TO role1;
```
- Granting the permission to delete all databases and tables
```
GRANT DROP ON test_db.* TO role1;
```

Deleting a role

DROP ROLE 'role_name' ON CLUSTER default_cluster;

Была ли эта статья полезна?