MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

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:
A
True
B
False
C
Either A or B
D
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.
Previous
Next