Postgres Pro
Downloads
Home   >   mailing lists

Re: getting permission denied error for user2 while proper privileges are present - Mailing list pgsql-sql

From Tom Lane
Subject Re: getting permission denied error for user2 while proper privileges are present
Date
Msg-id 525.1558154817@sss.pgh.pa.us
Whole thread Raw
In response to getting permission denied error for user2 while proper privilegesare present  (rajan <vgmonnet@gmail.com>)
Responses Re: getting permission denied error for user2 while properprivileges are present  (rajan <vgmonnet@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: rajan
Date:
Subject: getting permission denied error for user2 while proper privilegesare present
Next
From: rajan
Date:
Subject: Re: getting permission denied error for user2 while properprivileges are present