Privilege Type
Overview
The Privilege feature allows permission control through SQL statement combinations. In addition, for web editors, you can control data export/import and clipboard copy functions. SQL statements are classified according to ANSI SQL standards, and Redis provides separate Privilege Types.
Creating Privileges
When creating permissions, MySQL-based SET, SHOW, DESCRIBE, USE statements are basically included in all permissions.
Administrator > Databases > DB Access Control > Privilege Type
- Navigate to DB Access Control > Privilege Type menu from the Database settings menu.
- Click the
Create Privilege Typebutton in the top right. - Enter the following information for policy creation:
- Name : Name that can distinguish the permission on screen.
- Database Type : Select the type of database to which the permission is granted. Basically select General type.
- Privilege Type : Select the statements to allow execution with this permission.
- Functions : Select the operations allowed with this permission. You can control data export/import and clipboard copy functions within web editors.
- Save through the
Savebutton.
You can check that the permission has been created in the Privilege Type list.
How can I create and manage access permissions for Redis connections?
When selecting Database Type as Redis in the Privilege creation screen, you can create Privileges with separate Redis-specific permission types.
- Permissions allowed for execution when accessing Redis are largely classified into Read, Write, Dangerous, Etc.
- Read, Write, Dangerous, Etc. categories refer to Redis ACL Categories standards.
- Among selected categories, you can restrict by setting commands to restrict execution in Restrict Commands.