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 1950s on middle-aged women showed them to be a particularly distressed group, vulnerable to depression and feelings of uselessness. This isnt surprising. If society tells you that your main role is to be attractive to men and you are getting crows feet, and to be a mother to children and yours are leaving home, no wonder you are distressed.”
—Grace Baruch (20th century)
“Who can control his fate?”
—William Shakespeare (15641616)