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.
• 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.

[edit] See also

• Data Definition Language
• Data Manipulation Language

v • d • e Database management systems Database models · Database normalization · Database storage · Distributed DBMS · Federated database system · Referential integrity · Relational algebra · Relational calculus · Relational database · Relational DBMS · Relational model · Object-relational database · Transaction processing Concepts Database · ACID · CRUD · Null · Candidate key · Foreign key · Primary key · Superkey · Surrogate key · Armstrong's axioms Objects Relation (Table) · View · Transaction · Log · Trigger · Index · Stored procedure · Cursor · Partition SQL Select · Insert · Update · Merge · Delete · From · Join · Union · Create · Drop · Start Transaction · Commit · Rollback · Truncate · Alter · Where Components Concurrency control · Data dictionary · JDBC · ODBC · Query language · Query optimizer · Query plan Database products: Object-oriented (comparison) · Relational (comparison) · Document-oriented

This database-related article is a stub. You can help Wikipedia by expanding it. v • d • e

This programming language-related article is a stub. You can help Wikipedia by expanding it. v • d • e