Re: View for procedure names

From: <michael_bialik_at_my-deja.com>
Date: Sat, 10 Jul 1999 20:55:03 GMT
Message-ID: <7m8bv4$dp8$1@nnrp1.deja.com>

Hi.
 Use DBA_OBJECTS instead of DBA_SOURCE.

  Michael.

In article <378668FD.123BC624_at_us.oracle.com>,   Pete Sharman <psharman_at_us.oracle.com> wrote:
> This is a multi-part message in MIME format.
> --------------92E107B490642B68073C3B4A
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> SELECT owner, name
> FROM dba_source
> WHERE type = 'PROCEDURE';
>
> Add OR type = 'FUNCTION' if you want them too.
>
> You need to be granted access to the DBA views for this to work. Or
just
> log in as you do in OEM since you have access to a privileged account
for
> that.
>
> HTH.
>
> Pete
>
> arivlin_at_my-deja.com wrote:
>
> > I am looking for a view that will list all procedures and their
owners.
> > there must be one in Oracle, because Oracle Enterprise Manager is
able
> > to list procedures. What is the view and what kind of permissions
do I
> > need to access it?
> >
> > Alex
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
> --
> Regards
>
> Pete
>
> --------------92E107B490642B68073C3B4A
> Content-Type: text/x-vcard; charset=us-ascii;
> name="psharman.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Pete Sharman
> Content-Disposition: attachment;
> filename="psharman.vcf"
>
> begin:vcard
> n:Sharman;Peter
> tel;fax:+1.650.633.1669
> tel;work:+1.650.607.0109
> x-mozilla-html:FALSE
> url:http://www.oracle.com
> org:Oracle University, Consulting and Vertical Education;Oracle
Corporation
> adr:;;500 Oracle Parkway M/S OPL-B1024;Redwood
Shores;California;94065;USA
> version:2.1
> email;internet:psharman_at_us.oracle.com
> title:Project Manager
> note;quoted-printable:=0D=0A=0D=0A **** The statements and opinions
expressed here are my **** =0D=0A **** own and do not necessarily

represent those of          **** =0D=0A **** Oracle
Corporation.                                             =20

****=0D=0A=0D=0A"Controlling application developers is like herding cats." =0D=0AKevin Loney, ORACLE DBA Handbook =0D=0A=0D=0A"Oh no it's not! It's much harder than that!" =0D=0ABruce Pihlamae, long term ORACLE DBA
> x-mozilla-cpt:;-1
> fn:Pete Sharman
> end:vcard
>
> --------------92E107B490642B68073C3B4A--
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jul 10 1999 - 15:55:03 CDT