When I am try to access a package from normal user/schema (non-sys user) I am getting below error:
/* ERROR WHILE READING SOURCE
SQL Error [942] [42000]: ORA-00942: table or view does not exist
*/
When accessing this package from SYS user/schema it looks fine.
Probably there are some permissions which are missing for non-sys user.
Can anyone please help me and let me know what needs to be done to resolve this?
I tried checking the permissions of non-sys user using below queries to check if there are any permissions specific to oracle packages:
SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE = 'USER2';
SELECT * FROM USER_ROLE_PRIVS WHERE USERNAME = 'USER2';
SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = 'USER2';
But couldn't find anything specific for packages, it seems that this is the right way maybe.