Re: newbie question about roles.

       no
       You will have to create a dynamic sql of the type
       select 'grant update on`|| table_name ||'to username;` from
       dba_tables where owner = 'schema name`;
       this when run and spooled will create a script which can be run
       to give the permission to the username/rolename for
       all tables.
       Rajiv