How to manipulate roles
Last modified: October 1, 2024
Security Manager provides an easy way to add, alter or remove roles visually without typing an SQL code. To open Security Manager, on the Database menu, select Security Manager.
Create a new role
- Open Security Manager.
- Click the Create Role button above the User List. Alternatively, right-click a role, and then select New Role from the shortcut menu.
- Fill the Role name field.
- Select the owner.
- Grant necessary roles and permissions to a role.
- Click the Save button on the Security Manager toolbar.
Edit a role
To edit a role account, open Security Manager, expand the Roles node, and then select a required role in the tree. After editing, click the Save button on the Security Manager toolbar to apply changes. If you want to discard changes, click the Undo button on the Security Manager toolbar.
Delete a role
Open Security Manager, expand the Roles node, and select Delete from the shortcut menu of a required role; or select a required role in the tree and press DELETE.
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.