Post reply

Reference Permission

  • March 12, 2010 at 1:32 pm

    #94644

    I know I will probably show my lack of knowledge (and experience) with this.

    But what is Reference Permission?

    I understand Select, Insert, Update etc.

    But what is Reference.

    Thank you,

  • March 12, 2010 at 1:58 pm

    #1133010

    The following Quote was taken from an article that can be found here

    http://www.builderau.com.au/program/sqlserver/soa/SQL-Server-Grant-access-but-maintain-security/0,339028455,320277786,00.htm

    Assigning REFERENCES permission allows the owner of another table to use columns in the table to which they've been granted that permission as the target of a REFERENCES FOREIGN KEY constraint with his or her table. However, that person won't be allowed to change the structure of the table they've been granted the permission for

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • March 16, 2010 at 5:57 am

    #1134356

    I'm not sure I follow.

    If I am the owner of Table_B and have reference permission to Table_A.

    I can use a column in Table_A as an FKey to my Table_B?

    Is this correct?

    If so then Reference does (or does not) grant access to any other permission i.e. Update? It would seem not.

    Thank you,

  • March 16, 2010 at 7:20 am

    #1134421

    Basically if I am reading it correctly the permission would be from the aspect of the foriegn key only. So the foreign key is given the permission to do anything that is needed including updates if needed for the key but the user could not physically connect and do anything with that permission.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

Viewing 4 posts - 1 through 3 (of 3 total)

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