Error querying suites info when installed without public synonyms
Using 3.1.7, but I don't believe this is a new issue.
I've followed the install guide to install privately into a schema, UT3, and I've allowed access to another schema, UT_USER. My installation process is...
@create_utplsql_owner.sql ut3 ut3 users @install.sql ut3 CREATE USER ut_user IDENTIFIED BY ut_user; GRANT "CONNECT" TO ut_user; GRANT "RESOURCE" TO ut_user; ALTER USER ut_user DEFAULT ROLE "CONNECT", "RESOURCE"; @create_user_grants.sql ut3 ut_user; @create_user_synonyms.sql ut3 ut_user;
When connected as UT_USER I can run suites OK, but I cannot query for them using get_suites_info.
Query
SELECT t.* FROM TABLE ( ut_runner.get_suites_info (a_owner => user, a_package_name => null)) t
Exception
ORA-00904: : invalid identifier
ORA-06512: at "UT3.UT_SUITE_MANAGER", line 821
ORA-06512: at "UT3.UT_RUNNER", line 201
ORA-06512: at line 1