Re: Impersonating Users in Cube Browser

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Except for the bug with dynamic totals we've got dynamic dimension security
working.

Dave mentioned you'd need to disconnect to test a second user.
I was after a way to disconnect from within the cube browser.

Thanks



Hi,

Dynamic security is a mechanism in AS that allows you to use one role that
contains the USERNAME function to change what members it can see based
connecting user¡¯s NT USERNAME.

More information here:

http://www.mosha.com/msolap/samples/Dynamic%20security.zip

Includes a ppt and sample data & instructions for how to setup and use
three techniques outlined in the ppt

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
Thread-Topic: Impersonating Users in Cube Browser
thread-index: AcYs+SliHsnHWw4LQ2+ymu+AbHsoSw==
X-WBNR-Posting-Host: 203.202.23.100
From: "=?Utf-8?B?QWNpdXM=?=" <acius@xxxxxxxxxxxxx>
References: <4A57B917-0C72-4A0A-956E-A3FC67DEDB3E@xxxxxxxxxxxxx>
<u3Sf4I1JGHA.1028@xxxxxxxxxxxxxxxxxxxx>
<08318B21-074B-4DB6-98BB-C501904B8EEA@xxxxxxxxxxxxx>
<RvZU2AwKGHA.3680@xxxxxxxxxxxxxxxxxxxxx>
<5D2A3886-1A0D-4D49-92F4-BC1F34D73C60@xxxxxxxxxxxxx>
<nQ5sutKLGHA.608@xxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Impersonating Users in Cube Browser
Date: Wed, 8 Feb 2006 13:46:47 -0800
Lines: 91
Message-ID: <85F495A5-16C4-4128-8E37-2E141F9C63FB@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.olap
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.olap:67018
X-Tomcat-NG: microsoft.public.sqlserver.olap

So it's not possible to "disconnect, change the user and then re-connect."
as
per the earlier posting by Dave?


"Peter Yang [MSFT]" wrote:

Hi,

You may want to "run as" a different Windows account to start Management
Studio.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no
rights.


--------------------
Thread-Topic: Impersonating Users in Cube Browser
thread-index: AcYraL2+lxmGmL0HRtS9wzQ+sVeZwA==
X-WBNR-Posting-Host: 203.202.23.100
From: "=?Utf-8?B?QWNpdXM=?=" <acius@xxxxxxxxxxxxx>
References: <4A57B917-0C72-4A0A-956E-A3FC67DEDB3E@xxxxxxxxxxxxx>
<u3Sf4I1JGHA.1028@xxxxxxxxxxxxxxxxxxxx>
<08318B21-074B-4DB6-98BB-C501904B8EEA@xxxxxxxxxxxxx>
<RvZU2AwKGHA.3680@xxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Impersonating Users in Cube Browser
Date: Mon, 6 Feb 2006 14:00:28 -0800
Lines: 30
Message-ID: <5D2A3886-1A0D-4D49-92F4-BC1F34D73C60@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.olap
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:66968
X-Tomcat-NG: microsoft.public.sqlserver.olap

Hi,

In the cube browser there's a button that let's you impersonate another
user. (It works once if you're using Kerberos).
Since we're using Dynamic user security we need to test multiple users
with
the same role. Dave mentioned you'd need to disconnect to test a second
user.
I was after a way to disconnect.

Thanks

"Michael Cheng [MSFT]" wrote:

Hi Acius,

It seems you could only use Windows Authentication to connect SSAS, I
believe "change the user" Dave means change another windows account
and
then try the relogin


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support
======================================================
When responding to posts, please "Reply to Group" via your newsreader
so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.








.

Relevant Pages