DCL commands are used to granting and revoking the permissions.

Ij
Posted by Ij under Oracle category on | Points: 40 | Views : 382
USING GRANT
This is used to grant the privileges to other users.
Ex:
SQL> grant select on student to sudha;
-- you can give individual privilege
SQL> grant select, insert on student to sudha;
-- you can give set of privileges
SQL> grant all on student to sudha;
-- you can give all privileges
The sudha user has to use dot method to access the object.
SQL> select * from saketh.student;

The sudha user can not grant permission on student table to other users. To get this
type of option use the following.
SQL> grant all on student to sudha with grant option;

Now sudha user also grant permissions on student table.
USING REVOKE
This is used to revoke the privileges from the users to which you granted the privileges.
Ex:
SQL> revoke select on student form sudha;
-- you can revoke individual privilege
 SQL> revoke select, insert on student from sudha;
-- you can revoke set of privileges
SQL> revoke all on student from sudha;	
-- you can revoke all privileges

Comments or Responses

Login to post response