Re: Web based application and Oracle user(s)

I am currently implementing some TMS Oracle reports using IIS 4.0 and ASP. I am using a DSN-less connection and dynamic SQL statements.

For ASP, a few excellent resources are

www.4guysfromrolla.com

www.asp-dev.com

www.askasp.com

www.activeserverpages.com

Is anyone else using ASP and Oracle? Please post some details on your applications.

Systems
Windsor Aluminum Plant
Ford Motor Company
( Phone: (519)-250-2610
* E-mail: ngill3_at_ford.com <<mailto:ngill3_at_ford.com>>

þWeb: www.windsoraluminum.ford.com

"Jim Lewis" <pojpl_at_ais.ucla.edu> wrote in message news:8tppah$jco$1_at_carroll.library.ucla.edu...
> One of the very helpful attributes of Oracle's WebDB product (the
> current 3.called Oracle Portal) is the storing of all
> reports, forms, etc. in the database as security
> for us. I know this doesn't answer your questions, but just in case
> you haven't seen WebDB in action, I thought I'd toss this out to you.
>
>
> Dave Godbey <luhbey_at_erols.com> wrote:
>
> >What are the options and the advantages for presenting Oracle housed
> >data in web based applications?
 

> >We are using Java servlets/JSP and ColdFusion in some of our
> >applications to select criteria, query an Oracle 8i database, and
> >prepare html pages for delivery of the information.
 

> >Specifically, we are currently having discussions on how best to handle
> >security and access to the database. Two current topics of discussion:
 

> >1. Create an Oracle user for each registered user (we have a manageable
> >number of users) and capture the user id and password during login and
> >authentication.
 

> >2. Create a single Oracle user that ColdFusion or JSP uses to access the
> >database, and use the web/application server to authenticate the user.
> >Knowing the identity of the authenticated user, limit programmatically
> >what data each user can get back.
 

> >Are there others? Are there any good papers or web sites that discuss
> >these issues?
> >Thanks,
> >Dave
>
>
>
>
>
Received on Thu Nov 02 2000 - 07:26:25 CST