Cube Security Roles

Last Post 17 Feb 2005 08:47 AM by PaulMcKibben. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

17 Feb 2005 08:47 AM
I have dimensions with custom security on them in my cubes. Every night the security definition gets corrupted and thus won't let my clients view the cubes.

A little background. The server is backed up using Veritas 9.1 every night starting at 8 p.m. and lasts until 10:00 p.m. At 11:05 p.m. every night, we perform an IIS reset. Every Sunday evening we re-boot the machine. We are utilizing the access db repository.

Each morning I check the access and find that the custom definition for the secuity is missing.

I would agree that we should migrate the repository to SQL because we are a SQL shop.

My questions are:

1. Is the select or deselect method of assigning custom security more stable?
2. Has anyone across this issue and how did you resolve it?

Thank you

Acceptable Use Policy