Toad for SQL Server 7.4 - Installation Guide

Principal

Displays the name of the user on which you want to set column permissions.

Table name

Displays the owner and name of the table on which you want to set column permissions.

Permission name

Displays the type of permission you want to set.

Column permissions

Select whether you want to allow or deny permissions for each column in the table.

Create and Alter Schemas

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 schema

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

Tip: To change the object's schema, right-click the object in the Object Explorer and select Change Schema.

Create and Alter Asymmetric Keys

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

An asymmetric key is one half of a key pair used to encrypt and decrypt a message where neither can be derived from the other.

Tip: You can change how objects display in the Object Explorer. For example, you can create custom categories or move objects out of existing categories (such as Programmability and Security) in Tools | Options | Explorer | Objects. See Object Options for more information.

To create or alter an asymmetric key

Select the Asymmetric Keys node under the Security node in the Object Explorer.
Select one of the following:
- Click to create an asymmetric key.
- Select an asymmetric key and click to alter it.
Complete the fields as necessary. Review the following for additional information:

Create from source

Select one of the following:

True—Select to import the asymmetric key pair.
False—Select to generate new asymmetric key pair.

Type source

Select one of the following:

Assembly, Executable File—Select to import public key from the corresponding object.
Strong File Name—Select to provide the path to the file.

Create and Alter Certificates

Certificates are used to encrypt data transmissions.

To create or alter a certificate

Select the Certificates node under the Security node in the Object Explorer.
Select one of the following:
- Click to create a certificate.
- Select a certificate and click to alter it.
Complete the fields as necessary. Review the following for additional information:

General options	Description
Generate new key	Select if you want to provide the subject for certificate.
Use existing file	Select if you want to provide assembly, strong file name or executable file.
Source options	Description
Type source	Select the item on which to base the new certificate. Strong Name File—Create the certificate based on an existing certificate file. Executable file—Create the certificate from an executable file that has been signed by the certificate. Assembly—Create the certificate from an assembly. Enter the name of the assembly. Note: The assembly must be already loaded in the SQL Server database.

Principal	Displays the name of the user on which you want to set column permissions.
Table name	Displays the owner and name of the table on which you want to set column permissions.
Permission name	Displays the type of permission you want to set.
Column permissions	Select whether you want to allow or deny permissions for each column in the table.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad for SQL Server 7.4 - Installation Guide

Set Column Permissions

Create and Alter Schemas

Create and Alter Asymmetric Keys

Create and Alter Certificates