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 <[EMAIL PROTECTED]> wrote:
>
> But of course a delete trigger is not called on a
> truncate...
>
> Ron Thomas
> Hypercom, Inc
> [EMAIL PROTECTED]
>
>
>
>
>
>
> MohanR@STARS-
>
>
> SMI.com To:
> [EMAIL PROTECTED]
>
> Sent by: cc:
>
>
> root@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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
