COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You can view a complete list of server-scoped permissions using the system function sys.fn ____ builtin ____ permissions:
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
Explanation:
Detailed explanation-1: -SQL Server includes a very useful system function sys. fn my permissions to list all the permissions of a particular principal (user or login) and this system function will help you list all permissions of a principal on a specific database object (securable).
Detailed explanation-2: -To check the user permissions in a SQL Server instance, you can query the sys. database permissions and the sys. database principals system catalog views.
There is 1 question to complete.