Before you place your SQL Server 2000 database into production, you must configure security to permit appropriate access for users and administrators. In this chapter, you will learn how SQL Server 2000 controls access to the server itself. Next, you will learn how SQL Server 2000 controls access to databases, including an introduction to server-wide and database-level permissions. Finally, you will learn to create security accounts (logins) for users using Windows authentication and SQL Server authentication.
To complete this chapter, you must have