Re: Restricted access on DataBases

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