Title: Installation on a schema with CREATE ANY CONTEXT fails for version 3.1.8 · Issue #992 · utPLSQL/utPLSQL · GitHub
Open Graph Title: Installation on a schema with CREATE ANY CONTEXT fails for version 3.1.8 · Issue #992 · utPLSQL/utPLSQL
X Title: Installation on a schema with CREATE ANY CONTEXT fails for version 3.1.8 · Issue #992 · utPLSQL/utPLSQL
Description: Recently we upgraded utPLSQL from version 3.1.7 to 3.1.8. Version 3.1.8 needs the CREATE CONTEXT privilege. Our DBA granted us this privilege with the CREATE ANY CONTEXT grant, but the installation fails with error: ERROR at line 1: 16:3...
Open Graph Description: Recently we upgraded utPLSQL from version 3.1.7 to 3.1.8. Version 3.1.8 needs the CREATE CONTEXT privilege. Our DBA granted us this privilege with the CREATE ANY CONTEXT grant, but the installation...
X Description: Recently we upgraded utPLSQL from version 3.1.7 to 3.1.8. Version 3.1.8 needs the CREATE CONTEXT privilege. Our DBA granted us this privilege with the CREATE ANY CONTEXT grant, but the installation...
Opengraph URL: https://github.com/utPLSQL/utPLSQL/issues/992
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Installation on a schema with CREATE ANY CONTEXT fails for version 3.1.8","articleBody":"Recently we upgraded utPLSQL from version 3.1.7 to 3.1.8. Version 3.1.8 needs the CREATE CONTEXT privilege. Our DBA granted us this privilege with the CREATE ANY CONTEXT grant, but the installation fails with error:\r\n\r\nERROR at line 1:\r\n16:33:47 [exec] ORA-20000: The following privileges are required for user \"XXX\" to install into schema \"XXX\"\r\n16:33:47 [exec] - CREATE CONTEXT Please read the installation documentation at http://utplsql.org/utPLSQL/\r\n16:33:47 [exec] ORA-06512: at line 27\r\n\r\n**Provide version info**\r\nVersion 3.1.8, on Oracle 12.1\r\n\r\n**Expected behavior**\r\nI expect that the installations cript runs without issues\r\n\r\n**Additional context**\r\nI found the issue in check_sys_grants.sql\r\n\r\n","author":{"url":"https://github.com/MickeVr","@type":"Person","name":"MickeVr"},"datePublished":"2019-09-12T07:16:19.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/992/utPLSQL/issues/992"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:30920528-8f2c-bea4-ddaf-4fd5af20ea06 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | DA74:3B1201:239889:32AB3C:6A631E25 |
| html-safe-nonce | 43c08897e91b2c707404e5f01cff0b3df027f7755957f64fb70ba103205939ef |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEQTc0OjNCMTIwMToyMzk4ODk6MzJBQjNDOjZBNjMxRTI1IiwidmlzaXRvcl9pZCI6IjM5NDQxMjYyNTg0ODY2NDgzNTciLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | b043d393bc4652707f1f581ed20dce4663b7d68bc09f51940e42ea9ecad380e5 |
| hovercard-subject-tag | issue:492628901 |
| 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/_view_fragments/issues/show/utPLSQL/utPLSQL/992/issue_layout |
| twitter:image | https://opengraph.githubassets.com/e032744478356e265223ca8d2a97647cfcd994f2a7fbd034b5deb38c95e183b6/utPLSQL/utPLSQL/issues/992 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/e032744478356e265223ca8d2a97647cfcd994f2a7fbd034b5deb38c95e183b6/utPLSQL/utPLSQL/issues/992 |
| og:image:alt | Recently we upgraded utPLSQL from version 3.1.7 to 3.1.8. Version 3.1.8 needs the CREATE CONTEXT privilege. Our DBA granted us this privilege with the CREATE ANY CONTEXT grant, but the installation... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | MickeVr |
| hostname | github.com |
| expected-hostname | github.com |
| None | 1a6c056e02f174fffc096c521ec0ff6fb83e40a2ec8cb8875466ec1524872dd6 |
| turbo-cache-control | no-preview |
| 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 | 6a93e25585f487ddff9e3996c06d5b869d6e1828 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width