Privileges On Procedures/Functions/Packages

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Aakash
    #1

    Privileges On Procedures/Functions/Packages

    hi,

    can anyone tell me which tables/views to refer to find
    the "execute" privileges given on objects like
    procdure/functions/packages ?

    its urgent .... any help will be appreciated.

    regards,
    aakash
    Tags: None
    • mcstock
      #2
      Re: Privileges On Procedures/Functions/Packages

      strangely, it's DBA_TAB_PRIVS (and related views like ALL_TAB_PRIVS,
      ALL_TAB_PRIVS_R ECD, etc.)

      also, there's no object_type column in this very old view, so you need to
      join with DBA_OBJECTS (or a related view) if you are looking for privs on a
      specified object type

      another anomaly in the data dictionary: you'll find VIEW column definitions
      in DBA_TAB_COLUMNS
      --
      Mark C. Stock
      email mcstock -enquery(dot)com
      Site Not Found | Framer
      https://www.enquery.com

      (888) 512-2048

      "Aakash" <daakash@yahoo. comwrote in message
      news:83fd0b82.0 311050520.7b2f4 ae2@posting.goo gle.com...
      hi,
      >
      can anyone tell me which tables/views to refer to find
      the "execute" privileges given on objects like
      procdure/functions/packages ?
      >
      its urgent .... any help will be appreciated.
      >
      regards,
      aakash

        Comment

        • Aakash
          #3
          Re: Privileges On Procedures/Functions/Packages

          thanks for the help mark.
          its really strange that DBA_TAB_PRIVS shud have info abt
          objects like procs/funcs etc. i was at my wits end
          trying to figure out where possibly they cud be.
          thanks again


          "mcstock" <mcstockx@xenqu ery.comwrote in message news:<7Y6dnT8YZ M-xmzSiRVn-ig@comcast.com> ...
          strangely, it's DBA_TAB_PRIVS (and related views like ALL_TAB_PRIVS,
          ALL_TAB_PRIVS_R ECD, etc.)
          >
          also, there's no object_type column in this very old view, so you need to
          join with DBA_OBJECTS (or a related view) if you are looking for privs on a
          specified object type
          >
          another anomaly in the data dictionary: you'll find VIEW column definitions
          in DBA_TAB_COLUMNS
          --
          Mark C. Stock
          email mcstock -enquery(dot)com
          Site Not Found | Framer
          https://www.enquery.com

          (888) 512-2048
          >
          "Aakash" <daakash@yahoo. comwrote in message
          news:83fd0b82.0 311050520.7b2f4 ae2@posting.goo gle.com...
          hi,

          can anyone tell me which tables/views to refer to find
          the "execute" privileges given on objects like
          procdure/functions/packages ?

          its urgent .... any help will be appreciated.

          regards,
          aakash

            Comment

            Previous template Next
            Working...