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:

    “To write it, it took three months; to conceive it three minutes; to collect the data in it—all my life.”
    —F. Scott Fitzgerald (1896–1940)

    “He took control of me for forty-five minutes. This time I’ll have control over him for the rest of his life. If he gets out fifteen years from now, I’ll know. I’ll check on him every three months through police computers. If he makes one mistake he’s going down again. I’ll make sure. I’m his worst enemy now.”
    —Elizabeth Wilson, U.S. crime victim. As quoted in People magazine, p. 88 (May 31, 1993)