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.

[edit] See also


Soft Eng logo This computer language-related article is a stub. You can help Wikipedia by expanding it.
Retrieved from "http://en.wikipedia.org../../../d/a/t/Data_Control_Language_f527.html"
In other languages