Connect to the database as a user with DBA authority or as a user with PROFILE authority.
Call the sa_server_option system procedure, setting the ProcedureProfiling option to ON.
For example, enter:
CALL sa_server_option( 'ProcedureProfiling' , 'ON' );
If necessary, you can see what procedures a specific user is using, without preventing other connections from using the database. This is useful if the connection already exists, or if multiple users connect with the same user ID.
Connect to the database as the DBA, or as a user with PROFILE authority.
Call the sa_server_option system procedure as follows:
CALL sa_server_option( 'ProfileFilterUser' , 'userid' );
The value of userid is the name of the user being monitored.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|