| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Revoke Delete
i.e. unless u dont have a truncate trigger instead .. lol
Create or Replace Trigger StopTruncatesAndDrops
Before TRUNCATE or DROP on database
WHEN (ora_dict_obj_name = 'MTRX_GAME_SESSION_FACTS'
AND ora_dict_obj_type = 'TABLE')
declare
begin
raise_application_error(-20211, 'Cannot Drop or
Truncate Fact Table!!');
end;
/
intrestin stuff aint it .. especially when the fact table holds millions .. of records i mean ;)
Deepak
--- Ron Thomas <rthomas_at_hypercom.com> wrote:Received on Tue Nov 27 2001 - 18:47:36 CST
>
> But of course a delete trigger is not called on a
> truncate...
>
> Ron Thomas
> Hypercom, Inc
> rthomas_at_hypercom.com
>
>
>
>
>
>
> MohanR_at_STARS-
>
>
> SMI.com To:
> ORACLE-L_at_fatcity.com
>
> Sent by: cc:
>
>
> root_at_fatcity. Subject:
> RE: Revoke Delete
>
> com
>
>
>
>
>
>
>
>
> 11/27/01
>
>
> 02:40 PM
>
>
> Please
>
>
> respond to
>
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
>
>
>
> set what, precisely, through a trigger?
>
> Geez, if you have a DBA and/or a schema owner that
> can't/shouldn't be
> deleting from a table, what you have is NOT a
> database problem, it's
> an HR problem.
>
> sheesh.
>
> yea, how about this? an "BEFORE DELETE" trigger on
> the table, saving and
> repopulating each row the Evil DBA deleted, and
> logging his Evil Actions
> in the Military Audit table, so that the Evildoer
> can be brought to justice?
>
> Yea, that's the ticket, that's printable in
> "Dilbert".
>
>
> In peace, love, data, and triggers,
>
> - The Evil One
>
>
> -----Original Message-----
>
> Hi Listers,
>
> How can we revoke 'delete privilege' from the schema
> owner of the table and
> also from DBA ?
> If it is not possible, can we set through trigger ?
> Thanks.
>
> Aldi
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Mohan, Ross
> INET: MohanR_at_STARS-SMI.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Ron Thomas
> INET: rthomas_at_hypercom.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__________________________________________________ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: deepakthapliyal_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |