Dear all,

I have created a web for users to access cube information. However, I want to do restriction access to certain people. I would like to know what is the common way to set security.
Thanks!

Best Wishes,
Polly

Hi,
Cube security is based on windows authentication. So
instead of having one web user, create cube roles and add
the domain users to that role for restricted access. Then
apply the roles to the cubes you wish.
Hope this helps.
Cheers,
Yash


certain people. I would like to know what is the common
way to set security.

Hi! Yash. Do you mean that I add the the domain users in "Cube Role" of AS? In the MDX query, can we use "Filter" or "Where" statement to restrict the access of certain people?

"Yash" wrote:

Polly,
You cannot, in an MDX statement, limit data depending on who is executing the query. MDX is not user sensitive.
You have to do what Yash suggests actually within AS.

Regards
Jamie


"Polly" wrote:

Polly,
I too agree with Jamie regarding MDX. You have to go for
Cube Roles. But if you are designing custom applications
to display data, then you can query cube roles with DSO.
Regards,
Yash

use "Filter" or "Where" statement to restrict the access
of certain people?

Thanks! Both of you.

Polly

"Yash" wrote:

Obviously Books Online (BOL) is a good resource for this topic and security
is covered quite extensively in many of the good Analysis Services books. In
particular, you might want to look at the Microsoft Press "Step-by-Step"
book
http://search.barnesandnoble.com/boo...sbn=0735609047

Also, since you asked specifically about web access, you might want to look
at the "Improved Web Connectivity" white paper at:
http://msdn.microsoft.com/library/de...l_datapump.asp
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Polly" <Polly (AT) discussions (DOT) microsoft.com> wrote