Data Control Language

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.
• REVOKE to cancel previously granted or denied permissions.

The following privileges can be GRANTED TO or REVOKED FROM a user or role:

• CONNECT
• SELECT
• INSERT
• UPDATE
• DELETE
• EXECUTE
• USAGE

In Oracle, executing a DCL command issues an implicit commit.

In PostgreSQL, executing DCL is transactional, and can be rolled back.

See also

• Data Definition Language
• Data Manipulation Language