2 Configuring the Sybase ASE Server for Monitoring

This chapter describes how to configure the Sybase Adaptive Server Enterprise (ASE) target to be monitored by Enterprise Manager Cloud Control.

To monitor the Sybase ASE target using Enterprise Manager, the Sybase ASE user must have the role mon_role. In addition to mon_role permissions, the monitoring user must also have Select permissions to access the following sys tables:

• syslisteners

• sysloginroles

• syssrvroles

The following commands will grant Select permission to the monitoring user:

grant select on syslisteners to public
go
grant select on sysloginroles to public
go
grant select on syssrvroles (name, srid) to public
go

The above steps will give Select permission to all existing users in the database. To grant Select permission to only the monitoring user, referred to as monuser below, run the following commands. To execute these commands, the user must have sa_role permissions.

1. Create a group.

   sp_addgroup OracleEMGroup
   go
   

2. Add the user monuser to the group.

   sp_adduser monuser, null, OracleEMGroup
   go
   

3. Grant Select permission on the tables to OracleEMGroup.

   grant select on syslisteners to OracleEMGroup
   go
   grant select on sysloginroles to OracleEMGroup
   go
   grant select on syssrvroles (name, srid) to OracleEMGroup
   go