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!
Received on Tue Sep 05 2000 - 14:41:09 CDT
