SQL - Data Control

Data Control

The Data Control Language (DCL) authorizes users to access and manipulate data. Its two main statements are:

  • GRANT authorizes one or more users to perform an operation or a set of operations on an object.
  • REVOKE eliminates a grant, which may be the default grant.

Example:

GRANT SELECT, UPDATE ON My_table TO some_user, another_user; REVOKE SELECT, UPDATE ON My_table FROM some_user, another_user;

Read more about this topic:  SQL

Famous quotes containing the words data and/or control:

    “This city is neither a jungle nor the moon.... In long shot: a cosmic smudge, a conglomerate of bleeding energies. Close up, it is a fairly legible printed circuit, a transistorized labyrinth of beastly tracks, a data bank for asthmatic voice-prints.”
    —Susan Sontag (b. 1933)

    “The mind is the greatest of all human forces. Control the mind and you control the body.”
    —Griffin Jay, Randall Faye, and Lew Landers. Armand Tesla (Bela Lugosi)