Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Monitoring Users
- Thread starter lgreyes
- Start date
Hi,
You may able to get a complete list of SQLs (including SELECTs) fired by logged users using:
select * from sysmaster:syssqexplain ;
However, pseudo table syssqexplain does not store user information. You may trace database related manipulations (DML, insert, update, delete) through "onlog" log browsing utility.
You may use "onaudit" trusted auditing features of the IDS to trace successful / unsuccessful activities made at a database / instance.
Thread below puts some light on onaudit usage etc.
Thread179-666979
Following is a link to informix Trusted Facility Manual wherein you will find more about onaudit facility:
Regards,
Shriyan
"The hidden flaw never remains hidden."
You may able to get a complete list of SQLs (including SELECTs) fired by logged users using:
select * from sysmaster:syssqexplain ;
However, pseudo table syssqexplain does not store user information. You may trace database related manipulations (DML, insert, update, delete) through "onlog" log browsing utility.
You may use "onaudit" trusted auditing features of the IDS to trace successful / unsuccessful activities made at a database / instance.
Thread below puts some light on onaudit usage etc.
Thread179-666979
Following is a link to informix Trusted Facility Manual wherein you will find more about onaudit facility:
Regards,
Shriyan
"The hidden flaw never remains hidden."
- Status
Similar threads
