OraFAQ Forum: General » How to get list of StoredProcedures names of a given user in Oracle

Home » Other » General » How to get list of StoredProcedures names of a given user in Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get list of StoredProcedures names of a given user in Oracle [message #103442]

Sat, 27 September 2003 00:28

Ali
Messages: 88
Registered: March 2000

Member

Hi All,
How to get the list of Stored Procedure names created by a given user in a Oracle 8i Database . I have the userid. I would like to know the query.

Please help me as fast as you can.

Regards
ali

Report message to a moderator

Re: How to get list of StoredProcedures names of a given user in Oracle [message #103451 is a reply to message #103442]

Tue, 07 October 2003 09:53

Matthew H
Messages: 1
Registered: October 2003

Junior Member

SELECT DISTINCT(name)
FROM dba_source
WHERE UPPER(owner) = UPPER('USER_NAME')
and TYPE = 'PROCEDURE'
/

/* replace USER_NAME with actual value */

Report message to a moderator

Re: How to get list of StoredProcedures names of a given user in Oracle [message #302453 is a reply to message #103451]

Mon, 25 February 2008 15:13

EGEC
Messages: 1
Registered: February 2008

Junior Member

SELECT distinct a.package_name,
a.object_name
FROM user_arguments a
order by a.package_name

creo que esta es la mejor manera, corrijanme si me equivoco, saludos

Report message to a moderator

Re: How to get list of StoredProcedures names of a given user in Oracle [message #302517 is a reply to message #302453]

Tue, 26 February 2008 00:26

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

After almost 5 years! I hope the previous version was goog enough for him. Smile

Maybe querying dba_objects is a better answer (if he does not want the name of procedures inside package).

Regards
Michel

Report message to a moderator

Re: How to get list of StoredProcedures names of a given user in Oracle [message #302728 is a reply to message #302517]

Tue, 26 February 2008 18:36

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Actually, I thought the same as yourself, until I LOOKED at 'user_arguments' and found that it contains the procedures and functions that live INSIDE a package.

The thread maybe old but the answer certainly was new.

David

Report message to a moderator

Re: How to get list of StoredProcedures names of a given user in Oracle [message #302786 is a reply to message #302728]

Wed, 27 February 2008 00:43

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I agree with you and this was the purpose of the smiley and the remark between brackets.
I just commented his answer and didn't think it is useless. Actually my remark was to emphasize the improvement of his answer.

Regards
Michel

Report message to a moderator

Previous Topic:	retail management system
Next Topic:	reports not running

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 21:38:25 CST 2024