hi,

I don't think you can issue a select privilege to a user for a whole schema. You could grant the 'select any table' privilege although this would allow that user to see any table in any schema.

You could write a simple script to create the sql needed to grant the select privilege to all tables in a schema.....

Something like this would work....

spool grant_sel.sql
select 'grant select on '||table_name||' to user2;'|| from user_tables;
spool off
@grant_sel

This should produce a file (grant_sel.sql) that contains a grant statement for each table in the schema of the user that ran the script. The it simply runs the script to grant the privileges....

Cheers

Moff.