DB2 Data Control Language

Transaction Control Language JOIN Statement

Advertisements


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


  1. GRANT
  2. 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

Transaction Control Language JOIN Statement

Advertisements