Red Hat build of Keycloak connected with Oracle database throws errors when deleting a role: "delete from "rhbk".SCOPE_MAPPING where ROLE_ID = ?, Error Message = ORA-00942: table or view does not exist"

Solution Verified - Updated -

Issue

  • On the Red Hat build of Keycloak Admin UI backed by an Oracle database, deleting realm roles fail with error "delete from "rhbk".SCOPE_MAPPING where ROLE_ID = ?, Error Message = ORA-00942: table or view does not exist"

Environment

  • Red Hat build of Keycloak
    • 22.x
    • 24.x
    • 26.x
  • Oracle Database
    • 19c

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content