How to manipulate application roles
Security Manager provides an easy way to add, alter or remove application roles visually without typing an SQL code. To open Security Manager, on the Database menu, select Security Manager.
Creating a new role
- Open Security Manager.
- Click the Create Application Role button above the User List. Alternatively, right-click a role, and then select New Application Role from the shortcut menu.
- Fill the Name, Password, Confirm Password fields.
- Specify a default schema.
- Grant necessary permissions to an application role and specify owned schemas.
- Click the Save button on the Security Manager toolbar.
Editing an Application Role
To edit an application role account, open Security Manager, expand the Application Roles node, and select a required application role in the tree. After editing, click the Save button on the Security Manager toolbar to apply your changes. If you want to discard the changes, click the Undo button on the Security Manager toolbar.
Deleting an Application Role
Open Security Manager, expand the Application Roles node, and then select Delete from the shortcut menu of a required application role; or select a required application role in the tree, and then press DELETE.
Want to Find out More?
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?