IDMS Server JDBC errors DB005520 DB005521 Missing authorization SYSCA.ACCESSIBLE_S

Products

• IDMS
• IDMS - Database

Issue/Introduction

IDMS Server JDBC access to the IDMS CV is getting error messages:

DB005521 V13 T49664 C1M339: Missing authorization for SYSCA.ACCESSIBLE_S.
DB005520 V13 T49664 C-4M324: Missing authorization, compilation terminated.

 

 

Environment

Release : 19.0

Resolution

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. 

 

Additional Information

The view is documented in section Set Up Database Access 

SYSCA.ACCESSIBLE_SCHEMAS
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.