8 out of 9 rated this helpful - Rate this topic

Summary: Configuring Permissions on Database Objects

SQL Server 2012

SQL Server 2005

Logins give users permissions to connect to SQL Server. Users are logins that can access a specific database. Use the GRANT statement to give users permission to read and to access and change the data.

A view is a single SELECT statement and looks like a table to the user. A stored procedure is one or more Transact-SQL statements that execute as a batch.

Next Lesson in Tutorial

Lesson 3: Deleting Database Objects

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD