sql server data warehouse: user security on dimension data for Analysis Services 2005 -- sql server data warehouse

user security on dimension data for Analysis Services 2005

Joe
4/10/2006 4:51:52 PM

sql server data warehouse:

Hi -

I am using roles in a cube to limit what data a user can see. When I go into
the cube browser and select the "change user" option and select a specific
role, the security works fine. However, when I log in as a user that is
clearly defined under that role, it doesn't take effect. Has anyone had a
similar experience?

Joe Lax
joelax@dbdirections.com

Re: user security on dimension data for Analysis Services 2005

Darren Gosbell
4/21/2006 12:00:00 AM

One of the first things to check is that the users in question are not
somehow being included in the Olap Administrators group. Olap
Administrators have access to _everything_ on the server.

It is also possible that the users could qualify for more than one role.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <I2w_f.3453$ee6.1859@trndny01>, nyogre@yahoo.com says...
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data warehouse group.