SQL Server Performance

Security problem

Discussion in 'Analysis Services/Data Warehousing' started by california6, Nov 2, 2007.

  1. california6 New Member

    I am having a weird security problem in my AS environment. Well the problem we are facing is with our home written application. The problem is as follows:
    1. Some users (there is no pattern) are not receiving the correct access to the time dimension after security is processed (through application)
    2. There is a property in the User file that should give all users read access to all members. But this is not working.
    3. Certain users only get access to the explicitly defined write access months in the users file.
    4. If a user does not have access to the 2005.APR member in the ACSTIME table, it is incorrect.
    Any reason as to why this is behaving this way? We did not change anything at the server or database level.
    Apprecaited any input.Thanks,
  2. satya Moderator

Share This Page