 |
 |
 |
|
 |
|
|
 |
 |
 |
Data control (DCL)
Data control commands in SQL control access privileges and
security issues of a database system or parts of it. These commands are closely
related to the DBMS (Database Management System) and can therefore vary in
different SQL implementations.
Some typical commands are:
GRANT- give user access privileges to a databaseDENY- deny user accessREVOKEwithdraws access privileges given with the GRANT or taken with the DENY command
Since these commands depend on the actual database management system (DBMS), we will not cover DCL in this module.
 |
|
|
|
|
|
|
|
