Groups > Databases > Oracle for ASP.NET > Re: Access DB Oracle and retrive role for users




Access DB Oracle and retrive role for users

Access DB Oracle and retrive role for users
Thu, 13 Mar 2008 14:14:43 +000
Hi..i'm working with Oracle DB for the first time and i need to understand some
general concepts such as...

 First.

I'm working on an asp.net 2 web application where a user inserts username and
pws in a login mask, post the form, the application creates the appropriated
connection string and the user is logged in. Is this right?

Second.

i how can i retive the role for the user just logged in? I need it to denie him
the access to such directories like administrator or somethinge else...

thank you
Post Reply
Re: Access DB Oracle and retrive role for users
Thu, 13 Mar 2008 18:45:12 +000
Yes.  You will need for your application to add a reference to
System.Data.OracleClient and you will need the Oracle Client software installed
on any machine you are deploying to.  Check out ConnectionStrings.com to see how
to build an Oracle Connection string for OracleClient.

 As for roles in Oracle, review this information:
http://www.adp-gmbh.ch/ora/misc/users_roles_privs.html
Post Reply
Re: Access DB Oracle and retrive role for users
Thu, 13 Mar 2008 18:53:39 +000
thankyou very helpfull
Post Reply
about | contact