Re: set roles in oracle

Reena see this
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html
/paght000013.asp
Patrick

"Reena" <rpaleja@xxxxxxxxx> wrote in message
news:#tUHTyyEGHA.3000@xxxxxxxxxxxxxxxxxxxxxxx
> In old ASP days...
>
> set oCnn = server.createobject("ADODB.Connection" )
> oConn.open [oracle connection string]
>
> oConn.execute("SET ROLE ADMIN IDENTIFIED BY pwd" )
>
> This will set role for that connection. When connection is closed, user
> access level goes back to their default role.
>
> How do I accomplish same thing with ASP.NET 2.0.
>
> Thanks in advance.
>
> - Reena
>
>
>
>
>
> --
> Sent via .NET Newsgroups
> http://www.dotnetnewsgroups.com


.

Relevant Pages

  • Re: set roles in oracle
    ... oConn.open [oracle connection string] ... oConn.execute("SET ROLE ADMIN IDENTIFIED BY pwd") ... This will set role for that connection. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Problems with establishing wireless connection and VPN connection before log on to daomain
    ... Log on to my computer using a domain user and pwd. ... Network ID ... connection doesnt pop up as an alternative. ...
    (microsoft.public.windows.server.networking)
  • RE: Default schema in oracle connection string
    ... As for the changing default schema in connectionstring when connecting ... Different provider may have different configuration properteis. ... | Can I change my default schema in oracle connection string? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: IIS/ASP/SQL Security Error
    ... Well if the DSN is working, then you need to add the same ... pwd that you used there to the connection string. ... > I've created and tested the ODBC connection just fine. ... > so there is no network access. ...
    (microsoft.public.inetserver.iis.activeserverpages)
  • Re: IIS/ASP/SQL Security Error
    ... Well if the DSN is working, then you need to add the same ... pwd that you used there to the connection string. ... > I've created and tested the ODBC connection just fine. ... > so there is no network access. ...
    (microsoft.public.inetserver.iis)
Loading