Re: grant execute question

From: <yewpc_at_my-dejanews.com>
Date: Thu, 01 Apr 1999 02:09:42 GMT
Message-ID: <7dukh0$1d0$1@nnrp1.dejanews.com>

In article <7duj96$cg$1_at_nnrp1.dejanews.com>, ewong74_at_netscape.net wrote:
> 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?

You can view it through DBA_TAB_PRIVS or ALL_TAB_PRIVS
>
> Thanks!
>
> Ed
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

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