Re: Restricted access on DataBases

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Durumdara <durumdara(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restricted access on DataBases
Date: 2016-09-14 14:52:08
Message-ID: 2615ad5e-eb9b-7265-4ae6-c1914f2bbc1c@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Durumdara 2016-09-14 15:12:38 Re: Restricted access on DataBases
Previous Message David G. Johnston 2016-09-14 14:26:50 Re: Dynamic query return