Security

SQL Server 6.0 security comprises several elements that¾working together¾allow you to define:

• The users who can log on to a SQL Server
• The users who can access each database on a SQL Server
• The database objects (tables, views, stored procedures) that each user is allowed to access and/or modify
• The Transact-SQL statements that each user is allowed to issue for each database that he or she has access to

SQL Server 6.0 gives you great flexibility for protecting your data. You can precisely determine which users are allowed to view and/or modify the information stored in your SQL Server 6.0 databases, in the tables and views of those databases, or even in individual columns. You also have the choice of administering users individually, or within the context of a group (thus simplifying some management tasks).

The chapters of this part explain how SQL Server 6.0 security interacts with security for Windows NT-based domains and computers, what the three types of SQL Server security are, what SQL Server 6.0 logins and database users are, and what SQL Server 6.0 object and statement permissions are. You will also learn about the tools that are used to perform each security management task, and how to perform these tasks.

Security topics are discussed in these chapters:

Chapter 8, Security Concepts

Chapter 9, Managing Security

Chapter 10, Remote Servers and Users