Re: Privileges; role hierarchy
- From: Jared Still <jkstill@xxxxxxxxx>
- To: paul.baumgartel@xxxxxxx
- Date: Thu, 9 Dec 2010 11:54:59 -0800
On Thu, Dec 9, 2010 at 7:43 AM, <paul.baumgartel@xxxxxxx> wrote:
> Before I start rolling my own, I though I'd ask whether anyone has
> developed a query or procedure to get this information. I'm using 11gR2.
>
> And yet another. :)
There are no version dependencies on this script.
clears.sql - does some session setup - called by following script
https://gist.github.com/735096
<https://gist.github.com/735096>get_all_privs.sql - just gets all privs for
a user, regardless of how granted
https://gist.github.com/735224
<https://gist.github.com/735224>
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
