Post reply

REFERENCES object permission

  • December 28, 2009 at 6:55 am

    #213934

    Hi,

    What is the significance of the below command?

    What if a user has this privilege?

    GRANT REFERENCES ON <table/view> TO <user>

    Thank you.

  • December 29, 2009 at 12:30 am

    #1096924

    Found by my self.

    REFERENCES permission means that a user who is the owner of table A can define a foreign key on table B, which she does not own, if she has REFERENCES permission on table B. REFERENCES permission is also used to allow a user to define a VIEW or UDF using the SQL WITH SCHEMABINDING option if the VIEW or UDF uses a table or view that is owned by a different owner.

    Hope this helps everyone!

Viewing 2 posts - 1 through 1 (of 1 total)

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