Automating Privilege Management
Greetings All;
We have a trio of messy trio of multiple-schema databases (version 11.1.0.7.0) where privileges have been granted all over the place just to "get things working" and now we're trying to claw some control back. To this end, I've written a procedure [in a package] that trawls through objects in each schema, intially reporting on and later actively "fixing" privileges according to rules that we've had all along, but just haven't enforced.
I've tried to make the procedure economical in that it finds the privileges granted on each object and only makes changes where it has to, which leads me to my problem. To be able to see
We have a trio of messy trio of multiple-schema databases (version 11.1.0.7.0) where privileges have been granted all over the place just to "get things working" and now we're trying to claw some control back. To this end, I've written a procedure [in a package] that trawls through objects in each schema, intially reporting on and later actively "fixing" privileges according to rules that we've had all along, but just haven't enforced.
I've tried to make the procedure economical in that it finds the privileges granted on each object and only makes changes where it has to, which leads me to my problem. To be able to see
0