Microsoft
70-432 · Question #228
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 correct answer is B. Option B. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(24 responses)- A4% (1)
- B79% (19)
- C4% (1)
- D13% (3)
Community Discussion
No community discussion yet for this question.