-
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..:-)
-
re: data dictionary question
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|