Hello:
I am trying to find if anyone here has seen this behavior before. (We are using SQL Developer to connect to the DB. We do not have DBA access.)
A user has been granted "CREATE PROCEDURE", "CREATE ANY PROCEDURE", "CREATE TABLE", "CREATE ANY INDEX" privileges.
This is also confirmed by using "select * from user_sys_privs" and "select * from session_privs"
The issue is that User is unable to create/debug any stored procedure, table or index.
When trying to create a new procedure/table/index, the error is "ORA-00942: table or view does not exist"
When trying to compile an exiting stored procedure, the error is "An error occurred while opening sqldev.nav:IdeConnections%.."
Has anyone encountered this issue and if so, could you please guide on what was the cause?