You use DCL statements to grant and revoke access to database objects and change ownership of those objects from one user or database to another. The results of DCL statement processing also are recorded in the Data Dictionary.
The following table lists some basic DCL statements. The list is not exhaustive.
|
Statement |
Action |
|
GRANT/REVOKE |
Controls privileges of the users on an object. |
|
GRANT LOGON/REVOKE LOGON |
Controls logon privileges to a host (client) or host group (if the special security user is enabled). |
|
GIVE |
Gives a database object to another database object. |