After CPUJAN2022 Grants On Database Are Failing (Doc ID 2888378.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

After CPUJAN2022 grants on database are failing


Example:
GRANT SELECT, UPDATE, DELETE, INSERT ON VW_GLB0_ABFRAGESPALTEN TO benutzer
  *
FEHLER in Zeile 1:
ORA-01031: Nicht ausreichende Berechtigungen

An attempt was made to perform a database operation without the necessary privileges.

The grant options set as below:
 GRANT SELECT, UPDATE, DELETE, INSERT ON VW_GLB0_ABFRAGESPALTEN TO ikbobj with grant option;

If ORA-1031 error occurs while updating self owned columns in a view, this
bug might have been hit.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.