Is there a way to grant select to a user on all tables owned by another schema and all future tables owned by that schema.
The alternative as I see it is granting select any table which I would like to avoid.
Tony's suggestion is very good, but I would also suggest doing this grant to a role rather than the user directly. If you ever need to add another user, or remove/restrict the access to the first user, it is much more time intensive to do. By using the trigger to grant to the role, you can in turn grant that role to any number of users, all of whom will get access to new tables in the schema as the triggrer grants them to the role.