MDS 2012 - Security & User Group RRS feed

  • Question

  • Hi Team,

    I need to feed a application with data from MDS database. For that, I have created subcription views. However, I need to validate the 'User Group' with respect to a model before providing the data from MDS.

    I am trying to understand the MDS database schema with respect to the security. My solution is to get the AD group from the down stream application, validate with the MDS security model and then provide only the required data from MDS.

    Kindly provide the required schema information of MDS database. To resolve the above issue.


    Arun Renganathan 


    Friday, April 26, 2013 2:39 AM


  • Hi Arun,

    Access to subscription views is not part of the MDS security model. If you want to control whether user accounts or a groups have access to the views or not, I recommend customizing MDS database security - i.e. add a new role (if you require more than one account) or just a user (if you require just one account) and assign specific permissions to specific objects - i.e., views.

    Kind regards,


    Friday, April 26, 2013 7:53 AM