Post reply

Permissions On view

  • September 4, 2014 at 4:43 pm

    #289752

    User has permission on a table in database A. He needs to use View in Database B, the view is created from table in database A. In order to select data from view does user needs to have permission on Database B? Let me know if you have any questions and concerns?

    Thanks

  • September 5, 2014 at 10:00 am

    #1743563

    User don't need further permission on Database B. User can run view from Database B using 3 part naming i.e. Select * from DataBaseA.SchemaName.ViewName.

    Note: I am considering user is minimum member of public role in DatabaseB to connect to DatabaseB.

  • September 8, 2014 at 1:30 am

    #1743788

    The user executing the query must be mapped to database B in order to access the view inthe first place. A securable on the view should then be configured for the user.

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

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