GRANT#
Grants permissions on a securable to one or more principals (users or roles).
Syntax#
Arguments#
- ALL [ PRIVILEGES ]
Grants all permissions applicable to the securable.
- permissions
A comma-separated list of permissions, for example
SELECT,INSERT,EXECUTE.- ON securable
The object the permissions apply to.
- TO principals
The users or roles that receive the permissions.
- WITH GRANT OPTION
Allows the principals to grant the same permissions to others.
Examples#
GRANT SELECT, INSERT ON dbo.Product TO analyst;