Home | Previous Page | Next Page   Configuring and Monitoring Dynamic Server > Configuration Parameters >

SECURESTATG

onconfig.std value
1
possible values
0 = All database administrators can run onstat commands to view running SQL statements.
1 = Users with GRANT DBA access to a database cannot run onstat commands to view running SQL statements.
takes effect
When the database server is shut down and restarted
refer to
IBM Informix Administrator's Guide

The onstat commands that show the SQL statement text that is executing on a session are normally restricted to DBA users. To remove this restriction, set the UNSECURE_ONSTAT configuration parameter to 1. Onstat commands that show SQL statements include the onstat -ses, onstat -stm, onstat -ssc, and onstat -sql.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]