Let us first see the syntax and analyze.
GRANT:
USE master;GRANT VIEW ANY DATABASE TO username;GO
WITH GRANT:
USE master;GRANT VIEW ANY DATABASE TO username WITH GRANT OPTION;GO
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, the username will be able to give the permission after receiving requests from other users.
No comments:
Post a Comment