none
MDS - br_user impersonation

    Question

  • Hi all, I'm having a problem with security context, hope someone can help put please.

    I've set up a custom BR rule in MDS that on data changing a stored proc is called which takes the MDS data and inserts it into a dimension table on a another database but within the same server.

    I have set- up a new UserLogin (call it MDS_shared) and am impersonating the mds_br_user via it, in the custom sp I am using Execute AS MDS_Shared.

    I've granted MDS_Shared the correct database mappings but I'm still getting the error...

    The server principal "MDS_Shared" is not able to access the database "xxx" under the current security context.

    Appreciate any suggestions,

    Many thanks!

    Monday, March 11, 2019 12:29 PM

All replies

  • Any suggestions please?

    Thanks!

    Wednesday, April 3, 2019 9:09 AM
  • May not help, but have you tried re-creating the login on the target database and re-establishing permissions ? If not, that would be the first thing I'd try.
    Thursday, April 11, 2019 3:24 PM