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)

    “There has been something crude and heartless and unfeeling in our haste to succeed and be great. Our thought has been “Let every man look out for himself, let every generation look out for itself,” while we reared giant machinery which made it impossible that any but those who stood at the levers of control should have any chance to look out for themselves.”
    —Woodrow Wilson (1856–1924)