RE: How to revoke delete right from my own table

From: David Sharples <dsharples_at_cerebrussolutions.com>
Date: Mon, 14 Jun 2004 18:56:39 +0100
Message-ID: <EA29A3FCC723674293FD6286D3F0513E77C331@louis.cerebrus.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: 14 June 2004 18:42
To: oracle-l_at_freelists.org; oracledba_at_LazyDBA.com 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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://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_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon Jun 14 2004 - 12:49:53 CDT