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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How many levels of sp nesting is possible?

580


Explain what is cte (common table expression)?

624


Tell me can we use custom code in ssrs?

588


Explain triggers in sql?

549


What is the default fill factor value?

574






Mention what are the different types of ssrs reports?

98


What are transactions and its controls?

611


Explain the properties of subqueries in sql server?

536


What is the purpose of linked server configuration in sql server?

547


Define cursor locking

546


What is the difference between stored procedure and user defined functions?

618


Explain transaction server auto commit?

531


What is table-valued sub query?

562


Tell me what is a linked server?

559


Why I am getting this error when dropping a database in ms sql server?

588