Summary

3 4

In this chapter, you've learned about SQL Server user and security management. You've seen how both database logins and database user accounts are used to allow access to the database, and you've learned how to create and manage logins and database users. You've also learned how database roles can make user management easier by allowing a set of permissions to be assigned to a group of users and by allowing those permissions to be modified in a single location. And you've learned about a special group of roles called fixed server roles, which are used to assign administrative permissions to users and DBAs. Finally we looked at a security enhancement included in SQL Server 2000 that enables security accounts to be securely passed between servers in a Windows 2000 environment. In Chapter 35, you'll learn about SQL stored procedures and optimizing your queries.



Microsoft SQL Server 2000 Administrator's Companion
Microsoft SQL Server 2000 Administrators Companion
ISBN: B001HC0RPI
EAN: N/A
Year: 2005
Pages: 264

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net