From: Tom Lane <tgl@sss.pgh.pa.us>
To: rajan <vgmonnet@gmail.com>
cc: pgsql-sql@postgresql.org
Subject: Re: getting permission denied error for user2 while proper privileges
 are present
In-reply-to: <1558152796956-0.post@n3.nabble.com>
References: <1558152796956-0.post@n3.nabble.com>
Comments: In-reply-to rajan <vgmonnet@gmail.com>
	message dated "Fri, 17 May 2019 21:13:16 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <524.1558154817.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Sat, 18 May 2019 00:46:57 -0400
Message-ID: <525.1558154817@sss.pgh.pa.us>
Precedence: bulk

rajan <vgmonnet@gmail.com> writes:
> Please someone help me on the below. Unable to understand why user2 is not
> having access.

Because you said "noinherit".  Per the CREATE ROLE man page:

INHERIT
NOINHERIT

   These clauses determine whether a role “inherits” the privileges of
   roles it is a member of. A role with the INHERIT attribute can
   automatically use whatever database privileges have been granted to all
   roles it is directly or indirectly a member of. Without INHERIT,
   membership in another role only grants the ability to SET ROLE to that
   other role; the privileges of the other role are only available after
   having done so. If not specified, INHERIT is the default.

			regards, tom lane