But one shouldn't forget that roles are not active inside PL/SQL.
I think that you should use role for all the grants and then grant the role to the users.
-- Best regards, Alex Gorbachev
http://blog.oracloid.com -- //www.freelists.org/webpage/oracle-l