October 5, 2010 at 1:35 pm
Hey all,
I found this GRANT statement in an old script I need help understanding:
GRANT REFERENCES ON [dbo].[vwMyView] TO [DumbDbaUser]
I am having a hard time finding more detailed specifications for the REFERENCES permissions. What does granting REFERENCES to a user do? Can some one point me in the right direction or give me a little better information than what I have found in BOL?
Thank you,
Jon
October 5, 2010 at 1:41 pm
Came across this SSC post
it contains this link: http://msdn.microsoft.com/en-us/library/ms191291.aspx
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 5, 2010 at 1:42 pm
See here: http://www.sqlservercentral.com/Forums/Topic672795-145-1.aspx
edit: disregard, same link that Shawn posted. Yay Google!
October 5, 2010 at 1:49 pm
Excellent. Thank you Shawn and Derrick. SSC never fails me. This is exactly what I needed. For some reason I couldn't find it in BOL or Google.
http://msdn.microsoft.com/en-us/library/ms191291.aspx
The REFERENCES permission on a table is needed to create a FOREIGN KEY constraint that references that table.
The REFERENCES permission is needed on an object to create a FUNCTION or VIEW with the WITH SCHEMABINDING clause that references that object.
Thanks again,
Jon
October 5, 2010 at 2:08 pm
Derrick Smith (10/5/2010)
Yay Google!
I used BING baby 😛
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply