Re: postgres db permissions - Mailing list pgsql-general

From Adrian Klaver
Subject Re: postgres db permissions
Date
Msg-id 556DF5F4.3020609@aklaver.com
Whole thread Raw
In response to Re: postgres db permissions  (Steve Pribyl <Steve.Pribyl@akunacapital.com>)
List pgsql-general
On 06/02/2015 11:04 AM, Steve Pribyl wrote:
> None of the roles have permissions on the postgres database.  At this
> point they don't have any permissions on any databases.
>
>
> I have noted that  "GRANT ALL ON SCHEMA public TO public" is granted
> on postgres.schemas.public.  I am looking at this in pgadmin so excuse
> my nomenclature.
>
>
> Is this what is allowing write access to the database?

Should have added to previous post-

Log into the postgres database using psql and do:

\dn+

>
>
> Steve Pribyl
> Sr. Systems Engineer
> steve.pribyl@akunacapital.com <mailto:steve.pribyl@akunacapital.com>
> Desk: 312-994-4646


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: postgres db permissions
Next
From: Steve Pribyl
Date:
Subject: Re: postgres db permissions