object privs granted to roles

hi everyone,
I'm looking for a solution for the following problem

We have about 80 table objects in one schema (Oracle 9.2) - called it
"Calc_Apps".

We created few roles for different groups of users (developer, tester, bizuser, guests, apps)
About 100 users accessing this DB.

We would like to grant object privileges from this schema (Calc_Apps) e.g to the role 'developer' ("create", "delete", "insert", "select" and
"update").

My concern is when we would grant these 5 object privileges of all 80 tables to the role "developer" (and a different selection of privileges to the role "tester" a.s.o.) we would have a) the maintenance of these privileges could get cumbersome and b) I fear we would blowup the DD too much.

On the other hand, we would like to avoid to grant system privileges like
"create any ..", "delete any ...", "insert any ..." a.s.o. to a
particular role because this privileges should only be applied to this particular schema ("Calc_Apps").

I wonder is there another (easy) way to grant those (object) privileges to a role or can you point me to related part of some documentation?

Any reply much appreciated.
If you need additional details, please let me know

TIA
Fred Received on Tue Dec 28 2004 - 22:35:11 CST