Permissions to access the OLAP Cube

P

Paul Douglas

How can permissions be set for OLAP cube so that they do not have to be
granted each time a new named cube is generated? We are running 2003 Server
SP1 and SQL 2000 level 3.

Each time we run a new cube the SA has to grant permissions to access that
new cube.
 
P

Paul Douglas

Renke,

Thank you for your reply, but our problem is not continuation of permissions
once granted to a named cube but how to inherit those persmissions
automatically when the cube name is a new or changed name, i.e. cube A has
permissions granted to user X. Cube B is run and permissions must be
regranted to user X to view this cube.
 
V

Victor

Consider the following structure in Analysis Manager:
EPM (This is the database or top level)
MSP_ASSN_FACT (Cube under EPM)
MSP_PORTFOLIO_ANALYZER (This is actually a Virtual Cube made up of
the other two)
MSP_RES_AVAIL_FACT (Cube under EPM)

If you create a role at the EPM database level, then that role is
propagated to the cubes that resided below it. If you create a new
cube under EPM then the new cube will automatically have the role
there.

If you are creating a new database with cubes underneath it then I do
not know how you can have it "inherit" the permission of another
database. If you are doing this programmatically (meaning you wrote an
app to build the new database and cubes) then you could
programmatically create the role(s) and set them accordingly. You do
something like this when you are extending the OLAP cube with Task
data. You have to add code to the MSPOLAPBREAKOUT.dll so the roles are
set properly in the cube that is generated with the Task data.

If I understand your question correctly, it sounds as if you would need
to write something that programmatically sets the permissions.

Thanks,

Victor
 
Top