| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Application Login
How about having each application append onto the password field a different
key? Their Oracle passwords would then be whatever they type plus the key.
If they use the wrong application, they will get a password failure.
If you can't do this, then a table could be created with the user and their permission. Then check this table during login.
Steve Monaghan
> -----Original Message-----
> From: Gillian M [mailto:zmkj04_at_yahoo.com]
> Sent: Tuesday, September 05, 2000 4:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Application Login
>
>
> You could create updatable views of he tables.
> Say you have 2 application. Prefix one set of views
> with A (the application name), and the other set of
> views with B.
>
> Have one application go against one set of views and
> create roles that have access to those views. Likewise
> for the other application.
>
> I hope you do not run into a deadlock situation
> though.
>
> G!
>
> --- Nosie <tekait11_at_bni.co.id> wrote: > Dear All,
> >
> > I build two different applications (different
> > windows menus), but both
> > application require the same object privileged
> > (select, insert, update on
> > the same tables, same database). Users are only
> > authorized for certain
> > applications, not both.
> >
> > How should I design the security so that a user in
> > one application can not
> > login from another application (though it has the
> > same objects privileged).
> >
> > Thanks so much.
> >
> > Sincerely,
> >
> > Nosie
> > < tekait11_at_bni.co.id >
> >
> > --
> > Author: Nosie
> > INET: tekait11_at_bni.co.id
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> --
> Author: =?iso-8859-1?q?Gillian=20M?=
> INET: zmkj04_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Sep 05 2000 - 15:05:50 CDT
 |
 |