Thursday, 21 August 2014

grant select on v$session, actually v_$session

 

grant select on v$session to PRODDTA ;

When you are enabling auditing for JDE, the data owner needs direct access to v$session.  Now, you get an ORA-02030: can only select form fixed tables/views

So then you change it to:

grant select on v_$session to PRODDTA ;

and it works

No comments:

Extending JDE to generative AI