Re: Dynamic Access in a Web based application

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

From: Rujuta Gandhi (rujuta_at_intraactionsoftware.com)
Date: 01/10/05 

Date: Mon, 10 Jan 2005 10:16:36 +0530

Hi,

thanks for ur valuable help but still I cant achieve the purpose. I have
used the connection string as follows.

Provider=msolap;Data Source=pratibha;Integrated Security=SSPI;Initial
Catalog=NewACDM;Persist Security Info=false;roles=Role1

this role1 denies access to each n everything. I have put that querystring n
I got this error.

Exception:Either the user, ???, does not have access to the NewACDM
database, or the database does not exist.

Then I changed the coonection string n switched to the role which was
accesssing everything. But it still gave the same error.

then I added the windows user everyone to the role which was allowing
everything n then it was working ok.

after that i switched connection to the role denying everything then also it
was getting everything.

does that mean that it still depends on the windows user. Or I have some
problems with the connection string I have used.

Can u help me out.

Thanks again

Ruju

"Rujuta Gandhi" <rujuta@intraactionsoftware.com> wrote in message
news:uOSxqE$8EHA.1400@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I am creating a web application. What I want is that when ever any user
> registers himself, I want to assign a role to him which I have defined in
> analysis service n according to his role when ever he requests the data
from
> cube the access permissions defined for this role should work as they
> should.. Means I will have to create the users for analysis services
> programmatically n also the role assignment too. I dont know how to do
this.
>
> Is it feasible? Can any one suggest anything?
>
> Thanks in advance.
> Rujuta
>
>

Relevant Pages

  • Re: Cant connect to DB
    ... Switch off anonymous access on Directory Security tab ... Windows user name and password. ... Sandy ... >have you tried with this connection string? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Error when connect to Analysis Service
    ... The connection string is "Provider=MSOLAP.2;Data ... Server - Windows 2003 Standard Server ... Analysis Service and SQL server 2000, ...
    (microsoft.public.sqlserver.olap)
  • SQL DATABASE ACCESS
    ... I want my vb6 app to access SQL in the following way: ... I've set up a special domain user that is also the dbo of the db I want to ... This user id and password is included in the connection string that I ... It's not using the windows user to connect to the db, ...
    (microsoft.public.sqlserver.server)
  • Re: Trying to find the currently logged on user
    ... >If you are supplying the Sql username and password in the connection string, ... Nope - it's using impersonation. ... "integrated security=SSPI" and it will then use the Windows user ...
    (microsoft.public.dotnet.framework.adonet)