Re: Oracle database Security.

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1073974709.992385_at_yasure>...
> Paul Drake wrote:
>
> > Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1073961243.210791_at_yasure>...
> >
> >>Michel Cadot wrote:
> >>
> >>
> >>>"Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de
> >>>news:1073922301.965720_at_yasure...
> >>>
> >>>
> >>>>Jesu wrote:
> >>>>
> >>>>
> >>>>
> >>>>>Hi,
> >>>>> Can any one suggest, how to prevent inserting or deleteing records
> >>>>>in oracle table through MS Access or VC ++ project window.
> >>>>>
> >>>>>Thanks in advance
> >>>>>Jesu.
> >>>>
> >>>>Sybrands solution will work. An alternative is to use the
> >>>>PRODUCT_USER_PROFILE table owned by SYSTEM.
> >>>>
> >>>>For information on how to use PUP and a simple demo go to:
> >>>>http://www.psoug.org/reference/pup.html
> >>>>
> >>>>PUP can be used to disable are very large number of basic capabilities
> >>>>on a per person and/or per product basis.
> >>>>
> >>>>For example the following insert statement:
> >>>>
> >>>>INSERT INTO product_user_profile
> >>>>VALUES
> >>>>('SQL*Plus', 'JSMITH', 'SELECT', NULL, NULL,
> >>>>'DISABLED', NULL, NULL);
> >>>>
> >>>>Disables the SELECT command in SQL*Plus for user JSMITH.
> >>>>
> >>>>--
> >>>>Daniel Morgan
> >>>>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> >>>>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> >>>>damorgan_at_x.washington.edu
> >>>>(replace 'x' with a 'u' to reply)
> >>>>
> >>>
> >>>
> >>>You're right but SQL*Plus disables the command because it is designed
> >>>to use PRODUCT_USER_PROFILE but this does not prevent any other
> >>>application access.
> >>>I mean you can't disable any access from MS Access or other applications
> >>>with PRODUCT_USER_PROFILE except those who are king enough to
> >>>look at this table if there are some restrictions for them.
> >>>
> >>>Regards
> >>>Michel Cadot
> >>
> >>Oops! You are correct. My apology for my faulty memory ... a problem I
> >>blame entirely on Percodan. ;-)
> >
> >
> > fiber, and lots of it.
> >
> > Pd
>
> Think that will glue together a broken tibia?
>
> I've got to tell you navigating the loo with crutches is not a lot of
> fun. And your suggestion seems to implicitly involve quite a few trips
> in that direction.

I was speaking from personal experience. when I had surgery for a hernia, percocets prescribed for pain. results are along the lines of eating nothing but wings by the dozen.

Hope you caught some big air right before the cruch.

Bones heal, chicks dig scars, glory is forever ...

Pd Received on Tue Jan 13 2004 - 10:34:54 CST