Granting and Revoking Roles
Security Manager allows granting and revoking roles. To do this, you should:
- Open Security Manager.
- Expand the Users node for granting privileges to a user or the Roles node for granting privileges to a role.
Note
The Role Editor is available for the MariaDB connections only.
- Select the required user or role.
- Switch to the Roles tab.
- Check the needed role or roles. Note that some roles can include other roles. You can determine this by the status of the check boxes near roles:
checked. Privileges included in this role are added to the user privileges. Note that some roles can be checked, if the user already has the corresponding privileges.
checked, but inactive. Some other role that is selected includes privileges of this role.
unchecked. Privileges of this role are not granted to the user.
- View the privileges granted by each selected role or roles on the
Global Privileges tab.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?