Chapter 15. Security and User Administration


Chapter 15. Security and User Administration

by Paul Jensen

IN THIS CHAPTER

  • An Overview of SQL Server Security

  • Authentication Methods

  • SQL Server Security: Logins

  • SQL Server Security: Users

  • SQL Server Security: Roles

  • Managing SQL Server Logins

  • Managing SQL Server Users

  • Managing Database Roles

  • Managing SQL Server Permissions

  • SQL Server Permission Approaches

  • Object Owners

  • Using Encryption

Managing SQL Server security involves controlling access to SQL Server and access to the databases and the objects they contain, as well as defining permissions for users who will perform administrative tasks . This chapter will examine the SQL Server security model and demonstrate the various ways to implement security.



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon

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