HOUR 22. SQL Server Permissions Validation
In the previous hour you learned about SQL Server authentication, the process of ensuring that only valid users work with your database. After users gain access to a database it is important that they have specific rights to objects within the database. In this hour you’ll learn:
• The types of permissions available
• How to work with table permissions
• How to work with view permissions
• How to work with stored procedure permissions
• How to work with function permissions
• How to implement column-level security
The Types of Permissions Available
When a user logs in to the server, SQL Server first authenticates him to ensure that he is a valid user. SQL Server then grants the user permission to ...
Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
