Which Transact-SQL statements should you execute?

You administer a SQL Server 2008 instance.
A database developer named User1 needs to view the definitions of all database objects in a
database and read data from all user-defined tables, views, and table-valued functions.
You need to set the required permissions for User1. Which Transact-SQL statements should
you execute?

You administer a SQL Server 2008 instance.
A database developer named User1 needs to view the definitions of all database objects in a
database and read data from all user-defined tables, views, and table-valued functions.
You need to set the required permissions for User1. Which Transact-SQL statements should
you execute?

A.
Option A

B.
Option B

C.
Option C

D.
Option D



Leave a Reply 0

Your email address will not be published. Required fields are marked *