vasanth_m11

 Profile Answers by vasanth_m11 

• Jan 4th, 2011

 

Grant option gives the user permissions to grant the privileges to other users.
In an example, we can say, "test1" and "test2" are the users of the database.

conn test1/********
user test1 connected....

Grant select on table_name to test2 with grant option;
Grant succeeded...
Table owned by test1 has been granted privileges to test1 with grant option...
Now the user test2 can grant the same select on privilege to the table owned by test1 to others.

sirih1

 Profile Answers by sirih1 

• May 23rd, 2011

 

GRANT OPTION

1. We can grant object privileges only with grant option like (select,update,insert)
2. A--------->B--------->C

If A want to revoke privileges from C, it is not possible. The user who granted the privilege can only revoke. we have to revoke the privilege from B ,that automatically revoke the privileges from C.

sreekanth.g

 Profile Answers by sreekanth.g 

• Jun 22nd, 2011

 

assume that table 'emp' is created by user scott.
by using grant command he can grant privileges to other users.
If he want to provide a privileges to grant the privileges to other users
he has to grant a privileges with grant option.

vinoth

• Jul 15th, 2011

 

giving privilege to the user