IDMS Server JDBC access to the IDMS CV is getting error messages:
Release : 19.0
The JDBC userid needs to be granted access to the view SYSCA.ACCESSIBLE_SCHEMAS. The IDMS JDBC driver uses this view.
The syntax is:
GRANT SELECT ON SYSCA.ACCESSIBLE_SCHEMAS TO userid;
The grant should be done in each dictionary the user will be connecting to.
The view is documented in section Set Up Database Access
This view returns a list of schemas containing tables accessible to the user. It is used by the JDBC driver to implement the DatabaseMetaData.getSchemas method, and is required for JDBC support. The ODBC driver does not use this view. This view is defined for releases after IDMS r15.0.