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.
Prerequisites
DBA or PROFILE authority.
Context and remarks
Many.
Connect to the database.
Call the sa_server_option system procedure as follows:
CALL sa_server_option( 'ProfileFilterUser' , 'userid' ); |
Results
The value of userid is that of the user being monitored.
Next
None.
![]() |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |