Granting permissions

You must grant permissions to the user ID that is used to monitor the Sybase Server.

Before you begin

Install the Sybase agent.

You must have the database administrator role to grant permissions.

About this task

The user ID that is used by the monitoring agent must have access to Sybase tables and the installed monitor tables.

You can perform the following tasks:

• Create a user ID for the monitoring agent.
• Grant permission to the new user ID and the installed monitor tables.

If you are not running the Sybase agent as root user, make sure that the user ID belongs to the Sybase group and has read-access to the Sybase log files.

Procedure

1. Enter the command for the operating system you are using.

   • Windows:

     cd install_dir\tmaitm6\SQLLIB
     

   • Unix:

     cd install_dir/misc
     

   Where, install_dir is the home directory where the Sybase agent is installed.

2. Use the isql command to log in to the Sybase Server as user sa.

3. Run the following command to configure the ID that is used by the Sybase agent to communicate with Sybase Server:

   1>sp_addlogin user_name, password 2>g
   

   Where:
   user_name is the user ID. By default, it is tivoli.
   If the user ID is not tivoli, edit the koygrant.sql file and change the tivoli to the correct user ID.

   password is the password of the user.

   Note: Location of the koygrant.sql file:

   • Windows:
     install_dir\tmaitm6\SQLLIB
     Where install_dir is the home directory where the Sybase agent is installed.

   • Unix:
     /opt/ibm/apm/agent/misc/

4. Run the following command to grant permission to the tables in the database:

   isql -U sa -P password -S servername -i koygrant_filepathkoygrant.sql
   

   Where:
   password is the password of user sa.
   servername is the database server name.
   koygrant_filepath is at the following location:

   Note:

   • Windows:
     \opt\ibm\apm\agent\misc\

   • Unix:
     /opt/ibm/apm/agent/misc/

5. Run the following command to create proxy tables that are used for the installed monitor tables:

   isql -U sa -P password -S servername 
        -i $SYBASE/ASE-12_5/scripts/installmontables
   

   Where:
   password is the password of user sa.
   servername is the database server name.

What to do next

When the permissions are successfully granted, you can configure the monitoring agent.