What is the Difference between GRANT and WITH GRANT while Giving Permissions to the User?

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

What is Normalization?

Database normalization is a data design and organization process applied to data structures based on rules that help building relational dat...