Database User Permissions
Modified on: Fri, 9 Apr, 2021 at 2:23 PM
The database user configuration page can be accessed via the Configure button in the top left corner and then selecting Database User Configuration.
Database user's Permission is schema-based
You have the option to give database users different permissions depending on the schema. Simply check all the permissions you want the user to have for each schema in your system. If you want to give the user all permissions to all schemas you can click the 'select all' button to save time.
Can I see my database user's password after the user has been created?
No, when creating a database user you should store the password since you can not see the password again after the user has been created.
What if I forget the database user's password?
You can reset your database user's password by clicking the button 'Reset password'.
What happens if I create a new schema and want the user to have permission to that schema by default?
That is where the header checkboxes come in handy. Simply select the header checkbox for the permission you would like this user to have for all schemas in the system (even if you create a new one). That can save you time so you do not have to update all your database users when a new schema is created.
Sometimes you do not want that to happen, then just simply skip selecting the permissions header checkbox and select the permission for all the schemas instead.
Did you find it helpful?
Sorry we couldn't be helpful. Help us improve this article with your feedback.