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:

    “Mental health data from the 1950’s on middle-aged women showed them to be a particularly distressed group, vulnerable to depression and feelings of uselessness. This isn’t surprising. If society tells you that your main role is to be attractive to men and you are getting crow’s feet, and to be a mother to children and yours are leaving home, no wonder you are distressed.”
    —Grace Baruch (20th century)

    “Just as men must give up economic control when their wives share the responsibility for the family’s financial well-being, women must give up exclusive parental control when their husbands assume more responsibility for child care.”
    —Augustus Y. Napier (20th century)