Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
New: 14 April 2006
Logins give users permissions to connect to SQL Server 2005. 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
See Also
Other Resources
Security Considerations for Databases and Database Applications