grant execute question

From: <ewong74_at_netscape.net>
Date: Thu, 01 Apr 1999 01:48:25 GMT
Message-ID: <7duj96$cg$1@nnrp1.dejanews.com>

Hi,

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?

Thanks!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 19:48:25 CST