Dear Sir,
I am quite new the Postgre DB and working as DBA.
I wanted to set the grant all permissions on the database to the role.
Whatever the user assign to this role should inherits the same permissions on the database tables. To achieve this scenarios, I have executed below steps.
GRANT ALL ON database RM to RM_ADMIN_ROLE;
create user junkai;
ALTER ROLE junkai WITH LOGIN;
grant RM_ADMIN_ROLE to junkai;
I login using junkai, and try to access the tables, its giving the error as permission denied error.
If I grant the same access on table level, it’s working. I have hundreds of tables in the schema. I can’t grant the permissions on table level.
I have check in the internet, all suggesting same as above. When I run the above commands, it’s not throwing any error all says granted. When I do select, It’s not allowing to fetch the data.
Could you please help why it’s not working as expected?