Permissions in PL/SQL
Date: Thu, 9 Apr 2009 10:02:13 -0400
Message-ID: <0B43A9298955E14183B7AFAD4A11FC2106CC9B28_at_USHQEXVS.polanet.polaroid.com>
Greeting,
I am trying to expand my horizons by learning more about PL/SQL and convert an anonymous block I wrote ages ago into a procedure. I've learned that Types cannot be defined in a procedure so am building a package and have run into a problem. The code block selects from SYS-owned objects and X$KTFBUE. The original block was run from SYS, but I don't want go create the package there so I thought I could execute the create package from SYS with a different schema as owner (UTILITY) and the clause AUTHID CURRENT_USER to get similar permissions. I get compile errors indicating table access failures and I can't grant select on X$ tables. Am I missing something, or is my only choices to convert the code to use the DBA_LMT_USED_EXTENTS view instead or have SYS as the package owner? (Not about to use the 2nd choice.)
This is on a 9i database if that has any bearing.
Thanks,
Mike Hand
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 09 2009 - 09:02:13 CDT