Re: How to revoke delete right from my own table

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 14 Jun 2004 20:00:13 +0200

It's called a trigger.

SF

dba1 mcc wrote:

I have ORACLE database 9.2.0.5 under Solaris 8.  I
created a table and load data into it.  After data
load, I tried to "revoke delete" right from table and
get error meesage.  The message said I can NOT revoke
right whiich table I created.  I only need update and
insert right after I load data.  I want revoke
"delete" right to prevent accident delete or truncate
the data.  Does there has way to do it?


Thanks.




----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: