April 11, 2008 at 9:10 am
What is the difference between Grant and WithGrant??
I am trying to give permissions to an account and honestly I have not given it a thought in the past of the difference is.
Appreciate your help in advance.
User
X
Explicit permissions for X:
alter
contro
references
select Grant WithGrant Deny....
take ownership
view definition
JohnE
Cheers,
John Esraelo
April 11, 2008 at 9:35 am
WITH GRANT gives the ability to also GRANT that permission.
If you just GRANT SELECT to John, He can SELECT on the table.
If you GRANT SELECT and use WITH GRANT to Mary, not only can she SELECT on the table, she can also GRANT SELECT to others for that table.
K. Brian Kelley
@kbriankelley
April 11, 2008 at 9:41 am
you are the chosen one...
John Esraelo
Cheers,
John Esraelo
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply