GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — Installation on a schema with CREATE ANY CONTEXT fails for version 3.1.8 · Issue #992 · utPLSQL/utPLSQL

Installation on a schema with CREATE ANY CONTEXT fails for version 3.1.8 #992

New issue
Copy link
New issue
Copy link
Closed
Closed
Installation on a schema with CREATE ANY CONTEXT fails for version 3.1.8#992
Copy link
Labels
bug
Milestone
v3.1.9

Description

@MickeVr
MickeVr
opened on Sep 12, 2019
Issue body actions

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:33:47 [exec] ORA-20000: The following privileges are required for user "XXX" to install into schema "XXX"
16:33:47 [exec] - CREATE CONTEXT Please read the installation documentation at http://utplsql.org/utPLSQL/
16:33:47 [exec] ORA-06512: at line 27

Provide version info
Version 3.1.8, on Oracle 12.1

Expected behavior
I expect that the installations cript runs without issues

Additional context
I found the issue in check_sys_grants.sql

Activity

  1. MickeVr
    added a commit that references this issue on Sep 12, 2019

    Fix check of sys grants with ANY (issue utPLSQL#992)

    3ef06eb
  2. jgebal commented on Sep 13, 2019

    @jgebal
    jgebal
    on Sep 13, 2019
    Member
    More actions

    Micke,
    Thanks for reporting this issue.
    Even bigger thank you for fixing it!

    Great first contribution 👍

  3. jgebal
    added this to the 3.1.9 milestone on Sep 13, 2019
  4. jgebal
    added
    bug
    on Sep 13, 2019
  5. jgebal
    added a commit that references this issue on Sep 13, 2019

    Merge pull request #993 from MickeVr/develop

    976ab4d
  6. jgebal commented on Sep 27, 2019

    @jgebal
    jgebal
    on Sep 27, 2019
    Member
    More actions

    Closed by #993

  7. jgebal
    closed this as completedon Sep 27, 2019
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

    bug

    Type

    No type

    Projects

    No projects

      Milestone

      • v3.1.9

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      You are visitor 01402503 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.