Creating a Sybase user

To completely discover Sybase ASE on remote computer hosts, create a Sybase user assigned to an appropriate role.

To create a Sybase user, complete the following steps:

  1. Use the following command to create a Sybase user that is a member of sa-role.
    sp_role "grant",sa_role,IBM
    

    Ensure that the Sybase IQ user is a member of DBA. If the Sybase IQ user is not a member of DBA, the Sybase IQ database-specific information cannot be found.

  2. In the Discovery Management Console, complete the following steps to add the user name and password for the Sybase user in the TADDM server access list:
    1. To create an access list, click the Access List icon.
    2. In the Access List window, click Add.
    3. In the Component Type field of the Access Details window, click Database.
    4. In the Vendor field, click Database.
    5. Type the credentials (user name and password) to establish Java™ Database Connectivity (JDBC) to the Sybase server.