MSDN Webcast: Authorization, Privilege, and Access Control in SQL Server 2005 (Level 300)
Event ID: 1032334739
Language(s): English.
Product(s): Microsoft SQL Server.
Audience(s): Pro Dev/Programmer.
Data security is a big topic, but it all boils down to one simple principle: least privilege. By the principle of least privilege, a user should only have direct access to the bare minimum of resources required to do whatever it is the user needs to do. Microsoft SQL Server 2005 offers several new features that support least privilege design methodologies by providing you with more granular control of user access and enabling you to dynamically authorize users. In this webcast, we examine schemas, ownership chaining, impersonation, and module signing. Discover how each of these four factors fits into the security puzzle and helps you create simple yet robust schemes that ensure only properly authorized users can access your data.

Presenter: Adam Machanic, Database Software Consultant, Data Manipulation Group, Inc.

Adam Machanic is an independent database software consultant, writer, and speaker based in Boston, Massachusetts. He has implemented Microsoft SQL Server solutions for a variety of high-availability online transaction processing (OLTP) and large-scale data warehouse applications. Adam specializes in Microsoft .NET data access layer performance optimization. He has written for SQL Server Professional and TechNet Magazine, and he speaks regularly at user groups, community events, and conferences. Adam is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP). Adam is coauthor of Pro SQL Server 2005 (Apress, 2005) and author of Expert SQL Server 2005 (Apress, 2007).

View other sessions from: SQL Server 2005: Discover the Next Paradigm for Database Development.

If you have questions or feedback, contact us.
Register for event
Duration: 1 hour(s) 10 minute(s)
Add a calendar reminder