My Oracle Support Banner

ORA-04023: Object could not be validated or authorized while execute Select statement (Doc ID 2952790.1)

Last updated on JUNE 02, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 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:

*** 2023-01-19T17:11:15.475077+01:00 
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 "_b_tree_bitmap_plans"=TRUE';            <==
--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


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