RE: How to revoke delete right from my own table

  • From: "David Sharples" <dsharples@xxxxxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 14 Jun 2004 18:56:39 +0100

No you cant, as it is your table.

But why not create a new user and give them the appropriate privileges
then lock the account of the owner

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc
Sent: 14 June 2004 18:42
To: oracle-l@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx
Subject: How to revoke delete right from my own table

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
-----------------------------------------------------------------
----------------------------------------------------------------
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: