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

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

Kurt wrote:

> I never figured that into the scenario. For the sake of arguement, I
> suppose setting up one account/schema then utilizing Views to access the
> information. Any thoughts on this?
>
> -=Kurt=-
>
> C. Ferguson <c_ferguson_at_rationalconcepts.com> wrote in message
> news:37D184EF.A5255F8F_at_rationalconcepts.com...
> > You didn't go into what your front end was to this scenario. Are you
> creating
> > individual db accounts for each person? Are you letting some piece of
> software
> > use the company account to login? ... it basically depends on the
> architecture
> > of your system...
> >
> > regards,
> > Cindy
> >
> > Kurt wrote:
> >
> > > I got the different schemas part, but how would I set up John Smith to
> > > login?
> > >
> > > C. Ferguson <c_ferguson_at_rationalconcepts.com> wrote in message
> > > news:37D09090.A95B15CC_at_rationalconcepts.com...
> > > > different schemas for each company...and if you are not thinking along
> > > those
> > > > lines, why would you allow other companies to see/manipulate another
> > > companies
> > > > data?
> > > >
> > > > regards,
> > > > Cindy
> > > >
> > > > Kurt wrote:
> > > >
> > > > > Here's the scenario for Oracle 8i and/or WebDB on an NT4 server:
> > > > >
> > > > > 10 different companies say that want to use the database to store
> their
> > > > > sales. No other company should be able to access it.
> > > > >
> > > > > Each company wants one person to act as a MANAGER. MANAGERs have
> access
> > > to
> > > > > the sales of those whom report to them. The MANAGERs should also be
> > > able to
> > > > > add SALESMAN as their respective companies grow.
> > > > >
> > > > > Each SALESMAN should only see his own sales.
> > > > >
> > > > > 3 of the companies have a SALESMAN named "John Smith".
> > > > >
> > > > > Any recommendations/comments for setting up logins/security? How
> about
> > > the
> > > > > scenario itself? How do I keep John Smith from Company A separate
> from
> > > John
> > > > > Smith of Company B (apparently he's a boogie woogie bugle boy
> salesman).
> > > Am
> > > > > I making a mountain out of a mole hill? All the documentation I
> find
> > > seems
> > > > > to rely on the fact that it's only ONE company.
> > > >
> > > >
> >
> >
Received on Sun Sep 05 1999 - 02:13:44 CDT