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

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

Question Posted / guest

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

More SQL Server Interview Questions

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

What is difference between stored procedure and user defined function?

how can you check the level of fragmentation on a table? : Sql server administration

How to transfer data from a cursor to variables with a "fetch" statement?

What is a heap?

Explain system functions or built-in functions? What are different types of system functions?

Is the primary key column of a table an index in ms sql server?

Does a specific recovery model need to be used for a replicated database? : sql server replication

How do I completely remove sql server instance?

What is t-sql script to take database offline – take database online.

what is datawarehouse?

can you any body tell me which service pack is installed in the sql server?

For more SQL Server Interview Questions Click Here