DATA DICTIONARY QUESTION

[edsperez]

Can you give me the name of the data dictionary view that I can use to list all the procedure, package and function a user can execute.

The user does not own the said objects, he was just given an object priv. to execute the said objects.

Ed

[pando]

select object_name from all_objects
where object_type in ('PROCEDURE', 'FUNCTION', 'PACKAGE')

may be is this what you are looking for?

[edsperez]

The information in this table are those objects owned by a user. I'm looking for those (PROCEDURE,FUNCTION) that can be execute by a user through a 'grant execute on object_name ...' statement.

[pando]

how about

select owner, object_name from all_objects
where object_type in ('PROCEDURE', 'FUNCTION', 'PACKAGE')
and owner <> user
/

[aracnid]

You can view the dba_source (or user_source) gives you iformations only about func-proc-pack...and you can view the source code of them..:-)

[tangqiang]

Can you try this:

select a.object_name
from all_objects a, all_tab_privs b
where a.object_type in ('PROCEDURE','FUNCTION','PACKAGE')
and a.object_name=b.table_name
and (b.grantee='user' or b.grantee='PUBLIC') ;

Hope it helpful to you!


Tang Qiang