Lesson 2: Configuring Permissions on Database Objects
New: 14 April 2006
Granting a user access to a database involves three steps. First, you create a login. The login lets the user connect to the SQL Server Database Engine. Then you configure the login as a user in the specified database. And finally, you grant that user permission to database objects. This lesson shows you these three steps, and shows you how to create a view and a stored procedure as the object.
This lesson contains the following topics:
- Creating a Login
- Granting Access to a Database
- Creating Views and Stored Procedures
- Granting Access to a Database Object
- Summary: Configuring Permissions on Database Objects