How to grant execute to packages?
I have a newly created user which as only been granted CONNECT and
RESOURCE
priv. I try to execute some oracle packages and found that some
of them work
and some of them did not(I did not grant EXECUTE to any package).
eg. I can
execute DBMS_OUTPUT but I can't execute DBMS_SQL. What is the
reason? Is
there any view in data dictionary that I can check to see what package
has
been granted?
Ans:
You can view it through DBA_TAB_PRIVS or ALL_TAB_PRIVS