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:
Post a Comment