Beyond Security Basics: Suggested Strategies
In addition to object and statement permissions, you can combine various components within SQL Server to facilitate administration and provide improved security. Following is a list of suggested security strategies:
Role-based security management
Views for data security
Stored procedures for data security
Triggers for audit trails
Role-Based Security Management
In the corporate environment, users often work in groups. People in these groups require similar permissions to the database. Whenever multiple users require similar permissions, you should use role-based security. With role-based security, you reduce the number of GRANT, REVOKE, and DENY statements that must be maintained.
Before diving headfirst ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.