O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required