Re: Insulating DML access via a package

The way I`ve been doing it is by creating a package for each main table in my database. Within this package I created one procedure for each DML (Insert, update, delete). I also have a function that returns a type RECORD for retrieving records. When called, each procedure is passed values through IN parameters which are then used to perform the appropriate DML.

Cheers,

JD

On Wed, 20 Dec 2000 04:12:04 GMT, "Michael O'Neill" <mjoneill_at_email.com> wrote:

>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 Thu Dec 28 2000 - 18:59:52 CET