Hi Folks,


Can you please tell me how we find when a nickname was dropped and who dropped it ?

I have tried list history but it does not list the dropped nickname.

Please suggest.


Thanks,
Pandit

If you didn't audit your system, you're out of luck to determine something like this after the fact. You may be able to analyze the log files (if you have archival logging) to find the timestamp of the transaction involving the DROP NICKNAME.