Grant, deny, and revoke permissions to securables
You can use SQL Server Management Studio or the T-SQL DCL statements to grant, revoke, and deny permissions to securables.
Grant, deny, and revoke permissions to securables with T-SQL DCL statements
In this section, we will use T-SQL DCL statements to grant, deny and revoke permissions.
Granting permissions to securables with T-SQL DCL statements
We use the GRANT
keyword to grant permissions to securables. The basic syntax for the GRANT
statement is as follows:
GRANT permission [,…n] TO <grantee_principal> [,…n] [WITH GRANT OPTION] [AS <grantor_principal>]
We use WITH GRANT OPTION
when we want the user to grant the same permission to other logins.
For example, to grant Bob the SELECT
permission WITH GRANT ...
Get SQL Server 2014 Development Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.