Oracle security -- oracle id vs application tables

From: Crispin Lee <alltech_at_singnet.com.sg>
Date: 1997/07/10
Message-ID: <01bc8e0d$32bb8380$6301c8c0@earth>#1/1

HI,

Has anyone done some security control for custom made Oracle-based application?

I believe there are different views on whether security control for application should be using Oracle ID or using application tables. Need to compair the pro and con of these two methods.

We are currently designing a business application for the government and they say that security access should be handled by the Oracle RDBMS as it is proved and secured as compaired to using application tables. There will be 7000+ application users and I am against the ideas as I don't think creating 7000+ ORACLE ID is the way to go. And I need to get strong justification for adopting application tables approach. Can someone share with me their comments?

Thanks

Crispin Received on Thu Jul 10 1997 - 00:00:00 CDT