Product: Easy SQR Version 2.5.x - Oracle Version 7.x

Problem: After entering the username, password, and connect string for Easy SQR, the product hangs at Database Access. This happens because the Oracle database is missing some views that Easy SQR is atempting to access. In most cases, the missing views were ACCESSIBLE_TABLES and ACCESSIBLE_COLUMNS, however, in one case PUBLICSYN or SYSCATALOG were missing.

Solution: If ACCESSIBLE_TABLES and ACCESSIBLE_COLUMNS are missing, run the Oracle catalog6.sql script on the database as SYS. If PUBLICSYN and SYSCATALOG are missing, run the catalog.sql script. Running the script is done as follows in $ORACLE_HOME/rdbms/admin directory:

      $ sqlplus  sys/change_on_install (or other password)
      $ @catalog6

Addendum: Easy SQR accesses the following tables or views: DBA_CATALOG, DBA_TAB_COLUMNS, ALL_CATALOG, ALL_TAB_COLUMNS, ACCESSIBLE_TABLES, ACCESSIBLE_COLUMNS, USER_USERS, USER_ROLE_PRIVS, PUBLICSYN, *PRIVATESYN, SYSCATALOG, *SYSCOLUMNS and DUAL.

	   
          * Oracle version 5. Not required for versions 6 or 7.