Security RRS feed

  • Question

  • Hi

    I am having a user who needs to access only certain members(Records). I need to provide that row level security thru Hierarchy member.I achieved this however it is taking some lag time abt 5 to 10 mins to effectively apply the security changes.

    Is it common?Please help me out


    Monday, November 17, 2014 11:44 AM


  • Yes. It is by design.
    Calculate the member security for each member could be an expansive operation, depends on how many members that entity has and how many hierarchy security rules are set.
    So update the member security is back ground job triggered SQL server proxy.
    Every time, when the member are created/updated/deleted or hierarchy security setting, the service will just queue a message in the proxy queue. And it will take 5-10 minutes to be processed.
    There is some setting we can provide to speed up the process, like the queue check interval. But it won't be synchronously applied.

    • Proposed as answer by Vincent Chen (X) Wednesday, November 19, 2014 2:23 AM
    • Marked as answer by Charlie Liao Monday, December 1, 2014 9:41 AM
    Monday, November 17, 2014 9:06 PM