Grant on all in user's schema

Hi!

I was wondering if there was a way to grant a privilege on all the tables in the user's schema to some other user.

I am trying to do:

create role ROLE
/

grant select on

        (select table_name from sys.dba_tables where owner = 'USER')
        to ROLE

but it does not work because (select... 'USER') is not a valid table name.

Thank you.
k& Received on Tue Jun 04 1996 - 00:00:00 CEST