Post reply

Cross database views access

  • October 18, 2007 at 6:06 am

    #375916

    Sorry for being a newb but all my SQL colleagues are off today!

    I have a developer that has setup a view in database A that has a join to a view in database B. Now the users have full access to database A but not to B and so get an error. Do we have to give each user access to the view on Database B then?

    Any recommendations are welcome e.g use a role?

    Thank you

  • October 18, 2007 at 7:40 am

    #743117

    Hi,

    Actually as you mentioned, creating a role on Database B with the required access on required objects should be fine. (Im not sure if there is any other way). Later, adding users to that role would work.

    Renuka__

    [font="Verdana"]Renuka__[/font]

  • October 18, 2007 at 8:00 am

    #743135

    Renuka (10/18/2007)

    Hi,

    Actually as you mentioned, creating a role on Database B with the required access on required objects should be fine. (Im not sure if there is any other way). Later, adding users to that role would work.

    I second that. Assign access to the view through a role and then populate the role with database users as needed later.

    K. Brian Kelley
    @kbriankelley

  • October 18, 2007 at 9:18 am

    #743181

    Thanks to you both.

    As we speak the dba is creating a role and applying the relevant permissions to views and tables.

    Lee

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

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