Re: grant execute hanging!?

From: Chris Leonard <s_p_a_m_chris_at_hotmail.com>
Date: Mon, 3 Nov 2003 11:10:28 -0600
Message-ID: <9_vpb.158$9U4.23426@news.uswest.net>

Greg,

I can't help you with why the grant is hanging without more information, but one way to see what users have already been granted the execute privilege on DBMS_PIPE is to run this query:

select * from dba_tab_privs
where owner = 'SYS' and table_name = 'DBMS_PIPE'

Since DBMS_PIPE is a package, only the EXECUTE privilege applies to it, and these are all listed in DBMS_TAB_PRIVS. Of course, several GUI tools, such as the Oracle Enterprise Manager, will run the query for you and show you these permissions as well.

-- 
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

"Greg G" <ggershSNACK_at_CAKEctc.net> wrote in message
news:Zq6dnStAj5P4GTuiRVn-hQ_at_ctc.net...


>

> I'm trying to do a simple thing 'grant execute on sys.dbms_pipe to auser;'

>

> For some reason I cannot ascertain, this is hanging.  I can ctrl-c it,

> but I'm not sure why it's not completing.  It doesn't get any better if

> I try to grant to public.  There don't appear to be any locks or

> anything out of the ordinary happening.

>

> Also, is there any way to find out what privs have been granted on this

> package already?

>

> Thanks.

>

> -Greg G

>

Received on Mon Nov 03 2003 - 11:10:28 CST