grant references

Question

Post reply

grant references

RJ-476420

SSCarpal Tunnel

Points: 4806
More actions
March 10, 2009 at 2:35 pm

#97307

what is the purpose & use of "Grant References" while provided permissions to an User in SQLK5.
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 1

Hi

REFERENCES grants are used for foreign keys. See http://msdn.microsoft.com/en-us/library/ms191291.aspx .

Greets

Flo

RJ-476420 SSCarpal Tunnel Points: 4806 More actions · Answer 2

First, thanks for the reply.

I have three tables under a view. This view selects few columns from each table. I would like to given select permission & update permission to only few users. So when I use "Grant" whether I should just give them "Grant Select & Grant Update" or I have also got to give them "Grant References".

Thanks

dmoldovan SSCertifiable Points: 6334 More actions · Answer 3

Do you want to update the base tables through the view?

RJ-476420 SSCarpal Tunnel Points: 4806 More actions · Answer 4

RJ-476420

SSCarpal Tunnel

Points: 4806

March 11, 2009 at 10:28 am

#957656

yes.

dmoldovan SSCertifiable Points: 6334 More actions · Answer 5

If so, things are getting a little more complicated. See

http://msdn.microsoft.com/en-us/library/ms180800(SQL.90).aspx

As far as I know you'll need to grant permissions on the view.

As for the REFERENCES permission - it is used for foreign keys and also for defining a VIEW or UDF using the WITH SCHEMABINDING option if the VIEW or UDF uses a table or view that is owned by a different owner.