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