Course Content
Advanced Techniques in SQL
Advanced Techniques in SQL
Data Control Language
Data Control Language (DCL) is a subset of SQL used to control access to data stored in a relational database management system.
DCL commands are primarily concerned with granting or revoking privileges on database objects such as tables, views, and schemas.
DCL commands
The two main DCL commands are:
GRANT
: This command is used to give specific privileges to users or roles;REVOKE
: This command is used to remove specific privileges from users or roles that have been previously granted.
Privileges
Privilege | Description |
---|---|
SELECT |
Read data from a table or view. |
INSERT |
Insert data into a table. |
UPDATE |
Update data in a table. |
DELETE |
Delete data from a table. |
EXECUTE |
Execute stored procedures or functions. |
ALL PRIVILEGES |
Grant all available privileges on an object. |
CREATE |
Create new objects within a database or schema. |
CONNECT |
Connect to a database. |