granting to a ROLE syntactically indentical to GRANT TO USER
Our application requires to granting SELECT,INSERT,UPDATE,DELETE on about 250 tables in our schema to about 400 users.
Scenario behind it: We are migrating the database behind our application from SQLBASE (Gupta,Unify, Centura, you name it) to Oracle 11g
at a large customer's site.
The customer's Oracle administration has created our users in the Oracle database. My conversion program spits out all GRANT statements to all
users on all required tables. This is quite a lot and the admin person now is asking me whether it would be possible (she did it already)
to create a ROLE, give that ROLE the required GRANTS and then assigns that ROLE to the 400 users.