Database Explorer lets you perform operations on multiple users, roles, and schemas simultaneously using the shortcut menu. Right-click the selected users and roles in Database Explorer to access commands for specific tasks, such as editing, deleting, or generating scripts for users, roles, and schemas.
To select individual users or roles, hold Ctrl while selecting the users or roles. To select a range of users or roles, hold Shift.
To edit users:
1. In Database Explorer, right-click the selected users and select Edit User.
2. In Security Manager that opens, update the users’ details.
3. To save the changes, select Save on the Security Manager toolbar. Alternatively, press Ctrl+S.
For more information, see Manipulate user accounts.
To edit roles:
1. In Database Explorer, right-click the selected roles and select Edit Role.
2. In Security Manager that opens, update the roles’ details.
3. To save the changes, select Save on the Security Manager toolbar. Alternatively, press Ctrl+S.
For more information, see Manipulate roles.
To edit application roles:
1. In Database Explorer, right-click the selected roles and select Edit Application Role.
2. In Security Manager that opens, update the roles’ details.
3. To save the changes, select Save on the Security Manager toolbar. Alternatively, press Ctrl+S.
For more information, see Manipulate roles.
To edit schemas:
1. In Database Explorer, right-click the selected schemas and select Edit Schema.
2. In Security Manager that opens, update the schemas’ details.
3. To save the changes, select Save on the Security Manager toolbar. Alternatively, press Ctrl+S.
The following table describes the shortcut commands, which appear when you right-click the multiple users or roles in Database Explorer.
| Name | Description |
|---|---|
| Edit | Opens the Security Manager to update the users, roles, or schema. |
| Generate Script As | Generates a script for each selected object using the CREATE, DROP, and DROP and CREATE statements. The script can be saved to a new SQL document or a file, or copied to the clipboard. |
| Delete | Drops the selected users, roles, or schemas from the database. Alternatively, press Del. Note: You cannot undo the drop object operation, as it permanently deletes all its data and structure. It is recommended that you back up the database before deleting it. For instructions, see How to back up a SQL Server database. |