Re: How to know which databases and tables created/deleted yesterday?

DH wrote: > > Hi all, > > I would like to have a daily report of the list of datatabases and tables > were created or deleted yesterday. > > Is it possible to do that with IDS2000? Can I use Unix Shell script to query > it and run it everynight automatically with Unix cron deamon? I think the only thing that will cover that is secure auditing, but that does introduce an overhead on the system. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+