Re: Postgres 8.3 Grant all on database or schema

Hi Guillaume, Thanks for the update. I found some script to implement this. Regards, Saikumar From: Guillaume Lelarge Date: Wednesday, 7 November 2018 at 5:05 PM To: Saikumar Cc: "pgsql-generallists.postgresql.org" Subject: Re: Postgres 8.3 Grant all on database or schema Hi, Le

Re: Postgres 8.3 Grant all on database or schema

Hi, Le mer. 7 nov. 2018 à 09:59, Saikumar a écrit : > 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 dat

Postgres 8.3 Grant all on database or schema

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.