Planning Security

Administering SQL Server

Administering SQL Server

Planning Security

A security plan identifies which users can see which data and perform which activities in the database. To developing a security plan:

  1. List all the items and activities in the database that must be controlled through security.

  2. Identify the individuals and groups in the company.

  3. Cross-reference the two lists to identify which users can see which sets of data and perform which activities in the database.

See Also

Single Person Security Example

Small Company Security Example

Corporate Environment Security Example