Skip to content

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

Closed

Description

@MickeVr

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. jgebal commented on Sep 13, 2019

    @jgebal
    Member

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

    Great first contribution 👍

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

    @jgebal
    Member

    Closed by #993

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