Data Control Language
From Wikipedia, the free encyclopedia
A Data Control Language (DCL) is a computer language and a subset of SQL, used to control access to data in a database. Examples of DCL commands include:
- GRANT to allow specified users to perform specified tasks.
- DENY to disallow specified users from performing specified tasks.
- REVOKE to cancel previously granted or denied permissions.
- UPDATE to allow a user to update records
- READ disallows a user to edit the database, can only view the data
- DELETE allows a user to delete records in a database
In Oracle, executing a DCL command issues an implicit commit.
