Re: Here's a poser...any takers???

Thanks for all your help and information. You have given me a lot to think about. I really appreciate the input. Since this whole scenario is part of a class, there really wasn't much to go on as far as architecture. So throughout this "project" there hasn't been anything clear cut. I'm making assumptions as you have been. My only guess on this one is using HTML as a front end using the WebDB and having Oracle do all the work.

I was also going further by trying to figure out if Oracle should do all the work for authentication, or if NT does, or if the Application Server would be needed to complete the task.

From what I have envisioned from this exercise is that each company would basically do their own administration (but not be SQL+ saave). ie once the initial company was set up, each MANAGER would be able to add their own SALESMEN via an online form (html page?) containing the user name, and perhaps boxes or buttons to assign ROLES (Manager or Salesman). When a Submit button was clicked, the SQL would run to create the user using the input boxes. Once that was finished, the SALESMAN could log on to input their sales, contacts, etc.

            -=Kurt=-

C. Ferguson <c_ferguson_at_rationalconcepts.com> wrote in message news:37D21828.35BD308B_at_rationalconcepts.com...
> Ok Kurt,
> I don't see what a view is going to get you. Do you have a front end
to this
> scenario, or are you thinking you can accomplish this completely in the
> database?
>
> How are you going to identify who is a manager? How is this manager going
to
> add a salesman? Are these people db intelligent...i.e. do they know sql?
>
> From your original post, it sounds as if you are looking for a web
solution, so
> that usually means a web page interfacing with the db. (although I
believe
> oracle forms are web enabled now...). If it's a web page, this could be
> something simple as an html form, java script, and/or java applets.
>
> If you are envisioning this as people logging in via sqlplus, then views
might
> get you something...but this is not a web solution.
>
> Please take some time and think about these things...once you architect
front
> end to middle, to back end, it will become clearer what the database can
do for
> you.
>
> regards,
> Cindy
>
Received on Sun Sep 05 1999 - 15:11:13 CDT