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. due to the nature of at which this standard opperates it is possible for there to be problems within the sub system of the programming.

Examples of DCL commands include:

• GRANT to allow specified users to perform specified tasks.
• REVOKE to cancel previously granted or denied permissions.

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

• CONNECT
• SELECT
• INSERT
• UPDATE
• DELETE
• 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 · Referential integrity · Relational algebra · Relational calculus · Relational database · Relational DBMS · Relational model · Object-relational database · Transaction processing Concepts Database · ACID · Null · Candidate key · Foreign key · Primary key · Superkey · Surrogate key Objects Trigger · View · Table · Cursor · Log · Transaction · Index · Stored procedure · Partition SQL Select · Insert · Update · Merge · Delete · Join · Union · Create · Drop · Begin work · Commit · Rollback · Truncate · Alter Implementations Relational · Flat file · Deductive · Dimensional · Hierarchical · Network · Document-oriented · Object-oriented · Object-relational · Temporal · XML data stores · Triple stores Components Concurrency control · Data dictionary · JDBC · ODBC · Query language · Query optimizer · Query plan Database products: Object-oriented (comparison) · Relational (comparison) · Document-oriented