To enable one or more Sybase IQ users to authenticate a Sybase IQ server with Sybase Control Center, create and populate the SCC_MONITOR group.
Prerequisites
You are logged in to Sybase IQ as a user with DBA authority.
Task
To monitor a resource with SCC, you must authenticate the resource as a Sybase IQ user with DBA authority or membership in the SCC_MONITOR group.
Note: If you are performing a quick start, you need only authenticate your resource with Sybase Control Center using a Sybase IQ account with DBA authority (such as DBA). You can skip the steps below until you do a complete production set-up of SCC.
- Using Interactive SQL or another SQL command tool, execute scc_iq_monitor_privileges_setup.sql, located in the directory SCC-3_2/plugins/IQMAP.
The script creates the SCC_MONITOR group and grants a set of permissions.
- Assign one or more Sybase IQ users or groups to the SCC_MONITOR group. You can do this by either of these methods:
- Using Interactive SQL or another SQL command tool, execute grant membership in group SCC_MONITOR to <user/group>
- In a user interface tool such as Sybase Control Center or Sybase Central, add the user to the SCC_MONITOR group