How to revoke delete right from my own table

  • From: dba1 mcc <mccdba1@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx, oracledba@xxxxxxxxxxx
  • Date: Mon, 14 Jun 2004 10:42:00 -0700 (PDT)

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.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
----------------------------------------------------------------
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: