Roles grant permissions for which operations can be performed by a specific role. Roles are then assigned to database users.
1. Click into your instance
2. Click Roles
3. Click the plus symbol next to the type of role you wish to create.
Note: super_users have access to all operations, cluster_users are created to allow HarperDB to talk to HarperDB, and standard users have restricted permissions. It is recommended to create a standard user for most use cases such as development, reporting, and integration.
4. Name your role and click the checkbox
Note: Multiple users can have the same role and you ultimately may have many roles. Be descriptive in naming your role and make the name describe the types of permissions or function this role has for example, "developer", "reporting" etc...
5. Set permissions
Note: You may now select what permissions and roles has access to. Keep in mind all users with this role will have these permissions. The permissions are hierarchical - Schema/Table/Attribute. You can set READ, INSERT, UPDATE, DELETE permissions at each level. Removing READ permissions at a SCHEMA level for example will not allow the user to READ from tables, or attributes within that schema.