Re: how to know who alter my table

roger@star2000.com.tw wrote: > Davorin Kremenjas 寫道： > >> Read Trusted Facility Guide. >> >> <roger@star2000.com.tw> wrote: >>> [H]ow can I monitor which user alter my table? > > But if I did not setup audit, is there any other way to monitor which > user alter the table? Retroactively, it is not easy. If the database is logged, you could try looking through the logs, but it isn't recommended. The number of people with the privilege to do it should be small (as in 2-3); they would be the DBA, the table owner, and user informix. User informix should be under control - and so should the DBA and the owner. Who else could it be? If you don't have controls on who can operate as root and informix, for example, then even auditing wouldn't help very much. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/