Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to revoke delete right from my own table

Re: How to revoke delete right from my own table

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Mon, 14 Jun 2004 12:20:15 -0600
Message-id: <40CDEC5F.2080809@sun.com>


There is a sure-fire method. But it requires hardware modification. On each keyboard you use, remove the D, E, L and T keys.

:0

Daniel Fink

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.
>
> __________________________________________________
> 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 - 13:17:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US