Summary
The following are the key points on managing SQL Server logins and security:
SQL Server supports two authentication models: Windows Authentication and SQL Server Authentication. Windows Authentication is directly integrated with Windows 2000.
The guest user might exist in a database. SQL Server uses the guest login when a login is not mapped to a database. The guest user is a member of the public database role.
SQL Server supports several types of roles: server roles, database roles, and application roles.
Server roles are serverwide and cannot be customized.
SQL Server provides two types of database roles: predefined roles and user-defined roles.
Predefined database roles are database specific and cannot be customized.
Every database user ...
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.
