Impact of Liquibase warning "needs to access the SYS.DBA_RECYCLEBIN table" with Oracle 18c #19512

initshdb · 2023-04-04T05:09:12Z

initshdb
Apr 4, 2023

Greetings!

When I start KC 20.0.5 on Oracle 18c, I get the following warning thrown from Liquibase

Liquibase needs to access the DBA_RECYCLEBIN table so we can automatically handle the case where constraints are deleted 
and restored. Since Oracle doesn't properly restore the original table names referenced in the constraint, 
we use the information from the DBA_RECYCLEBIN to automatically correct this issue.

The user you used to connect to the database (KC20_TEST) needs to have "SELECT ON SYS.DBA_RECYCLEBIN" permissions set
before we can perform this operation. Please run the following SQL to set the appropriate permissions, 
and try running the command again.

GRANT SELECT ON SYS.DBA_RECYCLEBIN TO KC20_TEST;

While granting the permission corrects the warning, but in production the DBA needs justification why these rights should be given to SYS object.

I read some post on Liquibase that this grant is not mandatory and the warning can be ignored or suppressed, however I would like to know what is the impact on Keycloak of not granting the permission to SYS.DBA_RECYCLEBIN to the user?

Regards, Nitish

Navigation Menu

Repository navigation

Impact of Liquibase warning "needs to access the SYS.DBA_RECYCLEBIN table" with Oracle 18c #19512

Uh oh!

{{title}}

Uh oh!

Replies: 0 comments

Select a reply

Uh oh!

Impact of Liquibase warning "needs to access the SYS.DBA_RECYCLEBIN table" with Oracle 18c #19512

Uh oh!

initshdb Apr 4, 2023

Replies: 0 comments

initshdb
Apr 4, 2023