Alternatively, you might want to investigate GRANT SELECT ANY TABLE privs.