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.
--
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)
Received on Tue Jan 13 2004 - 00:19:46 CST
