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

Answers were Sorted based on User's Feedback



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

Answer / kunal sain

the said user will be eligible to grant the privilege to
other user.

Is This Answer Correct ?    11 Yes 0 No

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

Answer / soni

the user to whom we give privilege by with grant
option,he/she will also have authority to give privilege
to others.

Is This Answer Correct ?    10 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  


how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,


What are commonly used odbc functions in php?

0 Answers  


What is set nocount on?

0 Answers  


could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  






Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  


What are types of scd? : sql server analysis services, ssas

0 Answers  


Is port 1433 secure?

0 Answers  


i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,


Do you know the isolation level that sql server support?

0 Answers  


Which table keeps information about stored procedures?

0 Answers  


How to use column default values in insert statements in ms sql server?

0 Answers  


Categories