Right. For more details, read up the ORACLE DOC under the subject
definer-rights and envoker-rights.
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<88K29.767265$cQ3.118041_at_sccrnsc01>...
> yes. Don't grant them access to the tables in the first place and use the
> procedures for what you want to do.
> Jim
> "Stjepan Brbot" <stjepan.brbot_at_zg.hinet.hr> wrote in message
> news:aifov2$3c8u$2_at_as201.hinet.hr...
> > Is this possible (or is there any method) to hide tables for ordinary
> > users and allow them to access the data in tables only through group of
> > procedures/functions/packages? My intention is to create some code (like
> > API that will allow manipulation of data with business logic) for my
> > application but do not want users can corrupt data using direct DML-s!
> >
> > --
> >
> > Stjepan Brbot
> >
> >
> >
Received on Sat Aug 03 2002 - 11:42:50 CDT
