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?
Awaiting for your response.
Thanks,
Regards,
Saikumar
________________________________
Singapore Power and all members of the group are now serving the public as SP
Group. Our registered business address is 2 Kallang Sector, Singapore 349277
and our contact details have changed. Visit us at
spgroup.com.sg<https://www.spgroup.com.sg/> or connect with us at
fb.com/SPGroupSG<http://fb.com/SPGroupSG>
________________________________
This email and any files transmitted with it are confidential and intended for
the named recipient only. The contents herein are privileged to the sender and
the use thereof is restricted to the intended purpose. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. If you are not the intended recipient please do
not disclose, copy, distribute or take any action in reliance on the contents
of this e-mail. Thank you.
________________________________
