Configuring SAP Sybase IQ Roles-Based Users for Monitoring

For 16.0 and later databases, enable one or more SAP Sybase IQ role-based users or roles to authenticate an SAP Sybase IQ server with Sybase Control Center, create and populate the SCC_MONITOR role.

Prerequisites

Requires the MANAGE ROLES and MANAGE ANY OBJECT PRIVILEGE system privileges to execute the SCC_MONITOR script, which populates the SCC_MONITOR role.
Requires the MANAGE ROLES system privilege to grant the SCC_MONITOR role to any user or role.

Task

To monitor a resource with SCC, you must authenticate the resource as one of:

A SAP Sybase IQ user or role granted the MONITOR system privilege (minimum system privileges to monitor.
A member of the SCC_MONITOR role (maximum system privileges to monitor).

Note: If you are performing a quick start, you need only authenticate your resource with Sybase Control Center using the SAP Sybase IQ DBA user (granted maximum monitoring system privileges available) or an SAP Sybase IQ account granted MONITOR system privilege (the minimum system privilege required for monitoring). You can skip the steps below until you do a complete production set-up of SCC.

The SCC_MONITOR script must be executed for each managed resource.

Using Interactive SQL or another SQL command tool, execute scc_iq_monitor_role_based_privileges_setup.sql, located in the directory SCC-3_2/plugins/IQMAP.
The script creates the SCC_MONITOR role and grants a set of system privileges.
Assign one or more SAP Sybase IQ users or roles to the SCC_MONITOR role. You can do this by either of these methods:
- Using Interactive SQL or another SQL command tool, execute grant role SCC_MONITOR to <user/role>
- In a user interface tool such as Sybase Control Center, add the user or role to the SCC_MONITOR role