Toad for SQL Server 7.4 - Installation Guide

Select the Symmetric Keys node under the Security node in the Object Explorer.
Select one of the following:
- Click to create a symmetric key.
- Select a symmetric key and click to alter it.
Complete the fields as necessary.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create or alter a role

Select the Roles node under the Security node in the Object Explorer.
Select one of the following:
- Click to create a role.
- Select a role and click to create a role like the selected one.
- Select a role and click to alter it.

Complete the fields as necessary. Review the following for additional information:

Role Type

Select the type of role for the database. Valid values are:

Database role—restricts or grants access to the database based on SQL Server security.
Application role—restricts or grants access to data based on the application used to access the database. Application roles do not contain members.

Owned Schemas

Select the schemas owned by this role.

Members of this role

Displays the database roles or users assigned to this role.

Note: This list is only available if you select a Database role.

To create or alter a user-defined server role

Select the Server Roles node under the Server Security node in the Object Explorer.

Note: User-defined server roles are marked with red icon in the Object Explorer.
Select one of the following:
- Click to create a server role.
- Select a server role and click to create a server role like the selected one.
- Select a server role and click to alter it.
Complete the fields as necessary. In the General page specify logins and roles that will possess this server role. In the Memberships page specify server roles where the current server role will be included as a member.