Re: Uses of Dual
Date: 1996/08/22
Message-ID: <4vip3e$jk2_at_wabbit.its.uow.edu.au>#1/1
In article <321C826F.3870_at_concentric.net> Sharene Vitani, vitani_at_concentric.net writes:
>Phil Herring wrote:
>>
>> For a cruel practical joke, try adding an extra row to DUAL :-)
>
>Unfortunately, someone in my company must have seen your "practical
>joke". [...]
(Aah yes, the Internet... where people get the bomb recipes and instructions on how to stop Oracle applications.) Unless you changed the privileges on DUAL, it wasn't "someone", it was a DBA. I assume you know who your DBAs are.
>I recommend that people DON'T play unless they know the consequences to
>the user community and database.
A DBA dim enough to try a stunt like that on a production system ought not be a DBA. (But I guess you knew that already.) It is, however, reasonable to try such things on development systems to see what happens, just as it's reasonable to simulate disk failures. Forewarned is forearmed.
Copyright 1996 Phil Herring. This article may not be reproduced for profit.
Received on Thu Aug 22 1996 - 00:00:00 CEST