Getting started with SQL SELECT JOIN Example Databases and Tables UPDATE Indexes CREATE TABLE UNION / UNION ALL ALTER TABLE CASE INSERT Primary Keys ORDER BY GROUP BY Filter results using WHERE and HAVING Window Functions Common Table Expressions Views LIKE operator Functions (Aggregate)DELETE String Functions Data Types AND & OR Operators Triggers TRUNCATE MERGE Foreign Keys Finding Duplicates on a Column Subset with Detail Sequence Comments Subqueries Execution blocks Stored Procedures DROP Table Row number Transactions CREATE FUNCTION SQL Group By vs Distinct Table Design cross apply, outer apply Synonyms CREATE Database SKIP TAKE (Pagination)EXPLAIN and DESCRIBE Information Schema IN clause NULL SQL Injection Cascading Delete Order of Execution DROP or DELETE Database EXCEPT TRY/CATCH XML GRANT and REVOKE Functions (Scalar/Single Row)Relational Algebra EXISTS CLAUSE Materialized Views Functions (Analytic)SQL CURSOR Identifier Clean Code in SQL

GRANT and REVOKE

Remarks:

Grant permissions to users. If the WITH GRANT OPTION is specified, the grantee additionally gains the privilege to grant the given permission or revoke previously granted permissions.

Grant/revoke privileges

GRANT SELECT, UPDATE
ON Employees
TO User1, User2;

Grant User1 and User2 permission to perform SELECT and UPDATE operations on table Employees.

REVOKE SELECT, UPDATE
ON Employees
FROM User1, User2;

Revoke from User1 and User2 the permission to perform SELECT and UPDATE operations on table Employees.

Syntax:

GRANT [privilege1] [, [privilege2] ... ] ON [table] TO [grantee1] [, [grantee2] ... ] [ WITH GRANT OPTION ]
REVOKE [privilege1] [, [privilege2] ... ] ON [table] FROM [grantee1] [, [grantee2] ... ]

Contributors

Topic Id: 5574

Example Ids: 19791

This site is not affiliated with any of the contributors.