Create and Manage Privileges

The Privilege feature enables you to manage privileges based on SQL syntax-specific combinations. Additionally, for the web editor, you can regulate data export and import, as well as clipboard copy functionality. SQL syntax is categorized by ANSI SQL, and we offer a separate Privilege Type for Redis.

Create a Privilege

When creating permissions, the default set includes MySQL-based syntax such as SET, SHOW, DESCRIBE, and USE for all permissions.

1. In the Database Settings menu, navigate to DB Access Control > Privilege Type menu.

2. Click the Create Privilege Type button located in the upper-right corner.

3. Enter the following information to create the policy:

   1. Name : Enter a name to distinguish the authorization on-screen.

   2. Database Type : Select the type of database for which permissions are granted. By default, select the General type.

   3. Privilege Type : Select the syntax to allow execution with this privilege.

   4. Functions : Select the operations that are allowed with this privilege. You can control data export and import and clipboard copy functions within the web editor.

   5. Save your settings by clicking the Save button.

You will then find that the privilege has been successfully created and added to the Privilege Type list.

Q. For Redis connections, how do I create and manage access rights?

A. If you select Redis as the Database Type on the Create Privilege screen, you can create a privilege with the Redis-specific privilege type provided.

• The permissions to allow execution when connecting to Redis are categorized into Read, Write, Dangerous, and Etc.

• The Read, Write, Dangerous, Etc. categories are defined in Redis ACL Categories.

• Among the selected categories, you can restrict commands to restrict execution by setting Restricted Commands.

Related Topics

• Grant and Revoke Access Control

• DB Access Policies

• Authentication and Security Settings

Back to DB Access Control