Re: Oracle database Security.

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)