Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • What about using all_source or all_objects?
    • I had forgotten about those but most DBAs are reluctant to give grant select on any of the SYS owned stuff if they can help it.
      • by dhorne (7824) on 2007.04.11 17:49 (#54376)
        The all_* virtual tables should give you access to everything you own (as with user_*), plus what you have been granted by other users.

        To be honest, I wasn't aware of SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA'). Good to add to my bag o' tricks ;-)
        • I knew about SYS_CONTEXT because that's part of the magic behind Virtual Private Databases. I designed and coded one at work.