Re: Restricted access on DataBases - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Restricted access on DataBases
Date
Msg-id 2615ad5e-eb9b-7265-4ae6-c1914f2bbc1c@aklaver.com
Whole thread Raw
In response to Re: Restricted access on DataBases  (Durumdara <durumdara@gmail.com>)
Responses Re: Restricted access on DataBases
List pgsql-general
On 09/14/2016 06:52 AM, Durumdara wrote:
> Dear Charles!
>

>
> I thought before this test that mainuser get all rights as dbuser, so it
> have rights to the next (future) objects too.
> So mainuser and dbuser have equivalent rights in db database.
>
> Thanks for your every info!

In my previous post I mentioned using \dp or \z. The output from those
commands can be hard to understand without a key, which I forgot to
mention. The key can be found here:

https://www.postgresql.org/docs/9.5/static/sql-grant.html

in the Notes section.

>
> Regards
> dd
>
>
>
>
>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Dynamic query return
Next
From: Durumdara
Date:
Subject: Re: Restricted access on DataBases