Data Control Language

From Seo Wiki - Search Engine Optimization and Programming Languages

Jump to: navigation, search

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:

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

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

See also


de:Data Control Language

es:Lenguaje de Control de Datos fr:Langage de contrôle de données it:Data Control Language nl:Data Control Language ja:データ制御言語 pt:Linguagem de controle de dados uk:DCL zh:資料控制語言

Personal tools

Served in 0.130 secs.