Upgrade to 9.40, next question......

I seem to recall that onstat -g options are restricted, where is it documented and can it be changed? ~] onstat -g ses IBM Informix Dynamic Server Version 9.40.FC5 -- On-Line -- Up 1 days 22:04:12 -- 3212288 Kbytes Must be a DBSA to run this program Regards Colin There are 10 types of people in the world, those that understand binary and those that don't sending to informix-list

Colin Dawson wrote: > I seem to recall that onstat -g options are restricted, where is it > documented and can it be changed? > > ~] onstat -g ses > > IBM Informix Dynamic Server Version 9.40.FC5 -- On-Line -- Up 1 days > 22:04:12 -- 3212288 Kbytes> > Must be a DBSA to run this program If you're desparate - UNSECURE_ONSTAT 1 in $ONCONFIG. Unfettered access to other people's SQL by even DBSA/DBA types is something of a security risk. It can reveal passwords, social security numbers, salaries, and all sorts of other data that should not be revealed. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/