User Permissions for Sybase IQ
To monitor with a non-DBA account, you need:
- User account with SERVER OPERATOR system privilege.
Execution privileges on several procedures which can be granted as follows:
grant execute on sp_iqconnection to DBMon_Agent_User grant execute on sp_iqtransaction to DBMon_Agent_User grant execute on sp_iqcontext to DBMon_Agent_User grant execute on sp_iqstatus to DBMon_Agent_User grant execute on sp_iqcolumn to DBMon_Agent_User grant execute on sp_iqindex to DBMon_Agent_User
where
DBMon_Agent_User
is the user name under which you run the Database Visibility Agent.Grant DBA authority to
DBMon_Agent_User
:grant DBA to DBMon_Agent_User