Roles Editor (SQL Server)
Go Up to Microsoft SQL Server Object Editors
The Roles Editor lets you manage the users for a role.
To edit a role
- Open an editor on the role. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
| Tab | Settings and tasks | |
|---|---|---|
|
Properties |
Displays the Name, and either a Role Type of STANDARD and an Authorization Owner or a Role Type of APPLICATION and a Password. | |
|
Users |
Let you manage users for the role. A user becomes associated with an application role after running the target application. Use the Join Rule and Leave Role buttons to move users between the Users In Role and Users Not In Role lists. | |
|
Object Privileges and System Privileges |
For details on using these tabs, see Working with Privileges and Permissions. | |
|
DDL View |
For details on using this tab, see Viewing the SQL/DDL for an Object. | |
- 3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.