You assign User1 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT
OPTION enables User1 to:
A.
request a log of permission use.
B.
delegate permissions to other users.
C.
create new database users.
D.
view other users’ permissions.
From my own sight as ( WITH GRANT OPTION—the user (not roles) is permitted to grant the same permissions to other users ):
The Right Answer is :
B.
delegate permissions to other users.
10
0
Yes, the answer is B.
5
0
Sure, answer is B.
3
0
But the correct answer is B
2
0
This has told me that C is the right answer but i went for B,
which is the right answer and why?
1
0
The difference between these options is very simple. In case of only GRANT, the username cannot grant the same permission to other users. On the other hand, with the option WITH GRANT OPTIONS, the username will be able to give the permission to other users.
The correct answer is: – B
3
1
B is correct.
Explanation: https://blog.sqlauthority.com/2010/04/03/sql-server-difference-between-grant-and-with-grant/
1
0