Granting select to a role
I'm having an issue, where I want to create a role and grant select on all the tables in my database to that role.
So far as an example:
I've created the role, "create role tmp_role;"
granted usage on that role to all the schemas, "grant usage on schema tmp_schema to tmp_role;"
granted select on all tables to that role, "used a sql generated sql"
granted that role to the a user, "grant tmp_role to tmp_user;"
granted usage on schema to the user, "grant usage on schema tmp_schema to tmp_user;"
alter that user to have that as a default role, "alter user tmp_user default role tmp_role"
Seems I'm still not seeing any of the tables in the database.. is there something I'm missing when it comes to using roles?
Thanks for the help in advance