Which Transact-SQL statement(s) should you execute in the DB1 database?

You administer a SQL Server 2008 instance that contains a database named DB1. DB1
contains a table named Sales.Table1.
You need to obtain the effective permissions of a user named User1 to access the
Sales.Table1 table.
Which Transact-SQL statement(s) should you execute in the DB1 database?

You administer a SQL Server 2008 instance that contains a database named DB1. DB1
contains a table named Sales.Table1.
You need to obtain the effective permissions of a user named User1 to access the
Sales.Table1 table.
Which Transact-SQL statement(s) should you execute in the DB1 database?

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 *