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

Home -> Community -> Mailing Lists -> Oracle-L -> FW: finding "grant exec"

FW: finding "grant exec"

From: Yuval Arnon <Yuval.Arnon_at_wwfent.com>
Date: Wed, 20 Jun 2001 13:51:32 -0700
Message-ID: <F001.00330BD0.20010620122557@fatcity.com>

Look at dba_tab_privs. Contrary to the column name in dba_tab_privs the table_name column shows all procedures and packages.

For example:
SYSTEM> grant execute on dbms_pipe to scott;

Grant succeeded.

SYSTEM> select * from dba_tab_privs where grantee = 'SCOTT';

GRANTEE                         TABLE_NAME                           GRANTOR                         PRIVILEGE          

------------------------------  -----------------------------------  ------------------------------  
SCOTT                           DBMS_PIPE                            SYS                             EXECUTE            

Yuval.

-----Original Message-----
From: Fernando Papa [mailto:fpapa_at_elsitio.com.ar] Sent: Wednesday, June 20, 2001 2:57 PM
To: LazyDBA.com Discussion
Subject: finding "grant exec"

Hi everybody!

I have a problem, I did a lots of "grant exec" over a lot of packages
(there's no time to think...), and now I need to know every grant from any
user to a specified package. Somebody know what is the view that hold this information?

Thanks a lot!

--
Fernando O. Papa
DBA
El Sitio - Infraestructura

(54-11) 4339-3854
Received on Wed Jun 20 2001 - 15:51:32 CDT

Original text of this message

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