DCL
Summary
Data Control language is used for controlling of data by giving/revoking the access to retrieve the data based on the levels at users group level or individual user level . One of the main advantages of DCL is, User groups can be restricted by revoking the access for the sensitive data.DCL has mainly two statements
- GRANT
- REVOKE
GRANT -
GRANT statement is used to give the permissions which also used to add the additional permissions to users which already created earlier.
Syntax -
GRANT [statement] ON [DB_OBJECT] TO PUBLIC/Group-of-users
Example -
GRANT SELECT ON TABLE1 TO PUBLIC
In the above example, the query will give the SELECT access to all users which will have retrieve access to table existed database.
REVOKE -
REVOKE statement is used to revert the access which is granted earlier. It is also used to REVOKE the userid’s which are currently working.
Syntax -
REVOKE [statement] ON [DB_OBJECT] TO PUBLIC/Group-of-users
Example -
REVOKE SELECT ON TABLE1 TO PUBLIC