Cube creation/processing

[johnem]

Dear Listers,

We, (members of OLAP Administrators), are unable to create/process cubes unless the BUILTIN\Administrators local group is configured as 'sa'.

Surely this blows a hole in any security model.

Can access, to perform the above, be controlled via NT?

Any thoughts, work-around or sharing similar experiences are most welcome.

TIA

John

 

[MDXer]

You should be able to add any user to the OLAP ADMIN group but remember they must have permissions to the SQL server you are trying to build from.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck