locked
SERVER ERROR: The EXECUTE permission was denied on the object 'udpSystemSettingGet', database 'DB Name', schema 'mdm'. RRS feed

  • General discussion

  • Hi,

    I have given a user read and write access to certain entities. However, when the user tries to access MDS it is giving the following error;

    The EXECUTE permission was denied on the object 'udpSystemSettingGet', database 'DB_MDS', schema 'mdm'.

    Source Error:
    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    But when the "sysadmin" permission is grated, the user is able to access MDS but with access to all the entities.

    How can I resolve this?

    thanks in advance.

    Rohit


    Tuesday, March 5, 2013 6:54 AM

All replies

  • Bump - having this problem too.

    Todd McDermid's Blog Talk to me now on

    Friday, April 22, 2016 9:40 PM
  • Can you check what permission this user has from the "Functions" tab in security page? You will need to grant some basic "Functions" permission as well.

    Thanks

    Monday, April 25, 2016 6:06 PM