“ORA-00942 table or view
does not exist.:”
There are a
couple of things you could look at. Based on your question, it looks like the
function owner is different from the table owner.
1) Grants via a role : In order to
create stored procedures and functions on another user's objects, you need
direct access to the objects (instead of access through a role).
2) By default, stored procedures and SQL
methods execute with the privileges of their owner, not their current user.
If they
are access data direct in database means that is issue occur if table or view
not existing on schema or table or view don’t have grant permissions on
particular table or DML operations.
SELECT *
FROM all_objects
WHERE object_type IN
('TABLE','VIEW')
AND object_name =
'OBJECT_NAME';
If table
or view exists, still getting the issue means we need to give the permission to
user.
GRANT privileges ON object TO user;
Or If
you are getting the above issue on while connecting database through some GUI
applications then we need to give connect and resource permissions to the
current user.
Grant
Connect, Resource to <USER_NAME>
EmoticonEmoticon