Skip to content

Error querying suites info when installed without public synonyms #957

Description

@michaelstaszewski

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions