1/28/16

USING DCL

DCL commands are used to granting and revoking the permissions.

USING GRANT

This is used to grant the privileges to other users.


Syntax:

Grant <privileges> on <object_name> to <user_name> [with grant option];


Ex:

SQL> grant select on student to sudha; -- you can give individual privilegeSQL> 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.


Syntax:

Revoke <privileges> on <object_name> from <user_name>;


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

0 comments:

Post a Comment