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
Printable View
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
select object_name from all_objects
where object_type in ('PROCEDURE', 'FUNCTION', 'PACKAGE')
may be is this what you are looking for?
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.
how about
select owner, object_name from all_objects
where object_type in ('PROCEDURE', 'FUNCTION', 'PACKAGE')
and owner <> user
/
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..:-)
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