GeekInterview.com
Series: Subject: Topic:
Question: 8 of 89

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

Asked by: samarendra161 | Member Since Jun-2010 | Asked on: Jul 2nd, 2010

View all questions by samarendra161   View all answers by samarendra161

Showing Answers 1 - 4 of 4 Answers
vasanth_m11

Answered On : Jan 4th, 2011

View all answers by vasanth_m11

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.


Yes  2 Users have rated as useful.
  
Login to rate this answer.
sirih1

Answered On : May 23rd, 2011

View all answers by sirih1

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.

  
Login to rate this answer.
sreekanth.g

Answered On : Jun 22nd, 2011

View all answers by sreekanth.g

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.

  
Login to rate this answer.
vinoth

Answered On : Jul 15th, 2011

giving privilege to the user

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Oracle Backup and Recovery Interview Questions

Oracle Basics Interview Questions

Oracle Architecture Interview Questions

D2K Interview Questions

Data Access Interview Questions

Oracle DBA Interview Questions

Oracle security Interview Questions

Database Tuning Questions

Oracle Distributed Processing Interview Questions

Oracle Concepts Interview Questions

Oracle Memory Management Interview Questions

Oracle Forms Interview Questions

PL/SQL Interview Questions

Programmatic Constructs Interview Questions

RMAN Interview Questions

Real time Oracle Interview Questions

Oracle SQL Interview Questions

SQL*Plus interview Questions

Oracle System Architecture Interview Questions

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.