Closed
Description
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))
tException
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