Title: Issue · GitHub
Open Graph Title: Issue · utPLSQL/utPLSQL
X Title: Issue · utPLSQL/utPLSQL
Description: Testing Framework for PL/SQL. Contribute to utPLSQL/utPLSQL development by creating an account on GitHub.
Open Graph Description: Testing Framework for PL/SQL. Contribute to utPLSQL/utPLSQL development by creating an account on GitHub.
X Description: Testing Framework for PL/SQL. Contribute to utPLSQL/utPLSQL development by creating an account on GitHub.
Opengraph URL: https://github.com/utPLSQL/utPLSQL
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Error querying suites info when installed without public synonyms","articleBody":"Using 3.1.7, but I don't believe this is a new issue.\r\n\r\nI've followed the [install guide](https://github.com/utPLSQL/utPLSQL/blob/develop/docs/userguide/install.md) to install privately into a schema, UT3, and I've allowed access to another schema, UT_USER. My installation process is...\r\n\r\n```sql\r\n@create_utplsql_owner.sql ut3 ut3 users\r\n@install.sql ut3\r\n\r\nCREATE USER ut_user IDENTIFIED BY ut_user;\r\nGRANT \"CONNECT\" TO ut_user;\r\nGRANT \"RESOURCE\" TO ut_user;\r\nALTER USER ut_user DEFAULT ROLE \"CONNECT\", \"RESOURCE\";\r\n\r\n@create_user_grants.sql ut3 ut_user;\r\n@create_user_synonyms.sql ut3 ut_user;\r\n```\r\n\r\nWhen connected as UT_USER I can run suites OK, but I cannot query for them using [get_suites_info](https://github.com/utPLSQL/utPLSQL/blob/develop/docs/userguide/querying_suites.md).\r\n\r\n#### Query\r\n```sql\r\n SELECT t.*\r\n FROM TABLE (\r\n ut_runner.get_suites_info (a_owner =\u003e user, a_package_name =\u003e null))\r\n t\r\n```\r\n#### Exception\r\n```\r\nORA-00904: : invalid identifier\r\nORA-06512: at \"UT3.UT_SUITE_MANAGER\", line 821\r\nORA-06512: at \"UT3.UT_RUNNER\", line 201\r\nORA-06512: at line 1\r\n```\r\n","author":{"url":"https://github.com/michaelstaszewski","@type":"Person","name":"michaelstaszewski"},"datePublished":"2019-06-24T17:41:53.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/957/utPLSQL/issues/957"}
| route-pattern | /:user_id/:repository/issues/:id(.:format) |
| route-controller | issues |
| route-action | show |
| fetch-nonce | v2:577dc5ca-5af2-f691-87cc-89b3511aeb72 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 8130:1876D8:64ADFE:8D7EBC:6A63831D |
| html-safe-nonce | 11446c435d470b47953b5318438060cd4e880c84de324a0009d99cf9e93a17f1 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4MTMwOjE4NzZEODo2NEFERkU6OEQ3RUJDOjZBNjM4MzFEIiwidmlzaXRvcl9pZCI6IjgxMTM1NTI5NTMyMDk3NTAzMDEiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 3251835768fdac87d9ecb0bbc3a8adc19754a700efc84077e3d79e068e19872a |
| hovercard-subject-tag | repository:50728220 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/utPLSQL/utPLSQL/issues/957 |
| twitter:image | https://repository-images.githubusercontent.com/50728220/4935a380-d65f-11e9-9eb9-3536c94be03a |
| twitter:card | summary_large_image |
| og:image | https://repository-images.githubusercontent.com/50728220/4935a380-d65f-11e9-9eb9-3536c94be03a |
| og:image:alt | Testing Framework for PL/SQL. Contribute to utPLSQL/utPLSQL development by creating an account on GitHub. |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | e4fb64aef87da454ec25b158147f7f5f14aef29216e5ca1612c2e48faa599d1f |
| turbo-cache-control | no-cache |
| go-import | github.com/utPLSQL/utPLSQL git https://github.com/utPLSQL/utPLSQL.git |
| octolytics-dimension-user_id | 15661281 |
| octolytics-dimension-user_login | utPLSQL |
| octolytics-dimension-repository_id | 50728220 |
| octolytics-dimension-repository_nwo | utPLSQL/utPLSQL |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 50728220 |
| octolytics-dimension-repository_network_root_nwo | utPLSQL/utPLSQL |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | e839936ba5faffb9c836dda1cf4729d50c88a32e |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width