Custom authorization - CustomData RRS feed

  • Question

  • Hi all,

    I have a question, I want to implement my own authorization based on a value passed through the connection string using the CustomData keyword. Let me explain my situation:

    We have developed an application that using its own login system with userid's, usernames and passwords. Its (login) data is stored in a SQL Server database. Would it be possible to create a table with dimensions and dimension values with a relation to the user ud in the SQL Server database and use that info in the SSAS database to query what a user can access if we pass the userid through the connection string using the CustomData keyword? If so, can anybody provide me with a link or some directions on how to do so?

    If not, are there any alternatives?

    Best regards,

    Monday, December 27, 2010 9:09 AM