DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: DATA DICTIONARY QUESTION

  1. #1
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    151

    Talking

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    select object_name from all_objects
    where object_type in ('PROCEDURE', 'FUNCTION', 'PACKAGE')

    may be is this what you are looking for?

  3. #3
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    151
    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.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    how about

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

  5. #5
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    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..:-)

  6. #6
    Join Date
    Mar 2001
    Posts
    12

    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
  •  


Click Here to Expand Forum to Full Width