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 DP; -- you can give
individual privilege
SQL> grant select, insert on student to DP; -- you can give set of privileges
SQL> grant all on student
to DP; -- you can
give all privileges
The DP user has to use dot method to access the object.
SQL> select * from
saketh.student;
The DP 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 DP with grant
option;
Now DP user also grant permissions on student table.
