I wish to insulate DML access in an upcoming project. Rather than the
normal Oracle user that has almighty DML grants to the application's needed
database tables, I wish to have all DML statements executed via a custom
package (in Dynamic SQL, probably). In this way, I can manage some
important business rules and high granularity data quality issues that the
application isn't privvy from within the package body.
In other words the package will have DML grants. The application's user
account will have no DML grants but will be granted execute on the
aforementioned package.
Does anyone have a custom package they've already developped/downloaded and
matured a bit, so I'm not starting from absolute square zero?
Any guidance is appreciated.
--
Michael O'Neill
mjoneill_at_email.com
Received on Wed Dec 20 2000 - 05:12:04 CET
