a script to list all privileges for a user heirarchically

2003-07-15 Thread Pete Finnigan
Hi everyone I just answered a post on the server newsgroup from someone who wanted to know if a privilege had been granted to a particular user including mining through all of the roles granted hierarchically to roles etc. I posted a reference to a PL/SQL script I have knocked up as an answer

Re: a script to list all privileges for a user heirarchically

2003-07-15 Thread Rachel Carmichael
nice! and very usable, as I'm trying to mine through privileges and tighten security here. thanks much! --- Pete Finnigan [EMAIL PROTECTED] wrote: Hi everyone I just answered a post on the server newsgroup from someone who wanted to know if a privilege had been granted to a particular user