Hi,

I am finding that no one can connect to an AS2005 cube on my local machine
unless I give them full administrative privileges on the database in
question. Ideally I would just want them to be able to query the data in the
cube and nothing else. However, whenever I just try and set read privileges
for a role then the #N/A error appears.

I have found the error in books online under cell data privileges, however,
I have given read and read-contingent privileges to all cell data and still
the remote users cannot see any data, just #N/A.

Any ideas???

Colin