You can integrate SQL Server security with Windows NT security, allowing your application to benefit from Windows NT user authentication features. You can further restrict individual access to each database, and within each database you can determine which users are allowed to view or modify the various tables, columns, views, stored procedures, and rules. You also have the choice of granting access permissions individually or within the context of data access groups.
In order to understand basic SQL Server security and how it works with Windows NT to protect your enterprise application, you should become acquainted with the concepts included in the following topics in this section:
Note For a thorough discussion of SQL Server security concepts, search for "security" in the SQL Server Books Online.