Murach's SQL Server 2005 for Developers
How to manage database security

This chapter shows you how to configure security for a SQL Server system using either Transact-SQL or the Management Studio.
Chapter 17 How to manage database security
How to work with SQL Server login IDs 498
An introduction to SQL Server security 498
How to change the authentication mode 500
How to create login IDs 502
How to delete or change login IDs or passwords 504
How to work with database users 506
How work with schemas 508
How to work with permissions 510
How to grant or revoke permission to use an object 510
The SQL Server object permissions 512
How to grant or revoke permission to use the objects in a schema 514
How to grant or revoke database permissions 516
How to work with roles 518
How to work with the fixed server roles 518
How to work with the fixed database roles 520
How to work with user-defined database roles 522
How to display information about database roles and role members 524
How to deny permissions granted by role membership 526
How to work with application roles 528
How to manage security using the Management Studio 530
How to create login IDs 530
How to modify or delete login IDs 532
How to work with server roles 534
How to assign database access and roles by login ID 536
How to assign database role memberships 538
How to assign database user permissions to database objects 540
How to manage schemas 542
How to manage user-defined roles 544
How to work with database permissions 546
Perspective 548
t


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.