Home » Other » General » How to get list of StoredProcedures names of a given user in Oracle
How to get list of StoredProcedures names of a given user in Oracle [message #103442] Sat, 27 September 2003 00:28 Go to next message
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
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 Go to previous messageGo to next message
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 */
icon6.gif  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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
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 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: retail management system
Next Topic: reports not running
Goto Forum:
  


Current Time: Sun Dec 04 14:52:26 CST 2016

Total time taken to generate the page: 0.14790 seconds