Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dba_view to see privileges on procedures/packages/functinos

Re: dba_view to see privileges on procedures/packages/functinos

From: Roy Klassen <rklassen_at_pei.sympatico.ca>
Date: 1997/10/22
Message-ID: <01bcda87$3f9068c0$631e22cf@fred.sympatico.ca>#1/1

Michael:

You're looking at the right table if you're looking at dba_tab_privs.

It seems misleading because the column table_name can contain procedure names as well.

Roy Klassen rklassen_at_pei.sympatico.ca

Michael E. Moores <moores_at_digitech.net> wrote in article <876961167.13399_at_dejanews.com>...
> what view is there to obtain execute privileges on
> procedures and packages.
> all i can find is table privileges.
> (CC email to mmoores_at_digitech.net)
> --michael
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
  Received on Wed Oct 22 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US