How to set role programmatically using disconnected architecture

11-19-2007

I am developing a web application using .Net framework 2.0 and using
a disconnected architecture to connect to Oracle database.
Please let me know how and where I can specify the configuration to set the
role
similar to what we write in pl/sql for setting role as below:
set role <username> identified by <rolename>

--
Kumar.A.P.P
http://techaid.wordpress.com/

11-19-2007

You would need to use your Oracle .NET provider to execute an OracleCommand
with the P/L SQL Statement as the CommandText.

--Peter
"Inside every large program, there is a small program trying to get out."
http://www.eggheadcafe.com
http://petesbloggerama.blogspot.com
http://www.blogmetafinder.com

"Kumar.A.P.P" wrote:

> I am developing a web application using .Net framework 2.0 and using
> a disconnected architecture to connect to Oracle database.
> Please let me know how and where I can specify the configuration to set the
> role
> similar to what we write in pl/sql for setting role as below:
> set role <username> identified by <rolename>
>
> --
> Kumar.A.P.P
> http://techaid.wordpress.com/

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: How include a large array?	Edward A. Falk	C Programming	1	04-04-2013 08:07 PM
AzMan Role Based Security vs. ASP.NET Role Based Security	Kursat	ASP .Net Security	1	05-07-2007 01:33 PM
Role-Based Security: ACLs and Role Hierarchies	Liet Kynes	ASP .Net	0	11-26-2003 08:08 AM
Role-based security: Access the role of current user	Jesper Stocholm	ASP .Net	2	08-23-2003 06:59 PM
how can I use a signal defined in one Architecture to another Architecture	Muhammad Khan	VHDL	4	07-10-2003 06:14 PM