ORA-04023: Object could not be validated or authorized while execute Select statement
(Doc ID 2952790.1)
Last updated on FEBRUARY 26, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.
Symptoms
User was trying to run SELECT statement and hit ORA-04023: Object could not be validated or authorized
From generated errorstack trace file:
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
<error barrier> at 0xffffffffffefed0 placed dbkda.c@296
ORA-04023: Object could not be validated or authorized
----- Current SQL Statement for this session (sql_id=drq3kw6pdazjk) -----
SELECT .....
on same file we found:
begin
utente:= upper(sys_context('userenv','session_user'));
if utente in ('USER1','USER2')then
execute immediate 'alter session set cursor_sharing=''FORCE'''; <==
execute immediate 'alter session set optimizer_dynamic_sampling=0'; <==
--execute immediate 'alter session set optimizer_adaptive_features=false'; <==
execute immediate 'alter session set optimizer_features_enable=''11.2.0.1'''; <==
end
Changes
A logon trigger was created for specific users
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |