SQL SERVER Difference Between GRANT and WITH GRANT
Posted
on Dot net Slackers
See other posts from Dot net Slackers
Published on Sat, 03 Apr 2010 00:00:00 GMT
Indexed on
2010/04/03
4:53 UTC
Read the original article
Hit count: 436
Filed under:
This was very interesting question recently asked me to during my session at TechMela Nepal. The question is what is the difference between GRANT and WITH GRANT when giving permissions to user.Let us first see syntax for the same.GRANT:USE master;GRANTVIEW ANY DATABASETO username;GOWITH GRANT:USE master;GRANTVIEW ANY DATABASETO username WITHGRANTOPTION;GOThe difference between both of this option [...]...
Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
© Dot net Slackers or respective owner
