From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Wong, Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com>
cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: 101 Grants and Access Right Table/View
In-reply-to: 
 <CH0PR03MB6100645C5E5EF4CBD89AB31BFE472@CH0PR03MB6100.namprd03.prod.outlook.com>
References: 
 <CH0PR03MB6100645C5E5EF4CBD89AB31BFE472@CH0PR03MB6100.namprd03.prod.outlook.com>
Comments: In-reply-to "Wong,
 Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com>
	message dated "Thu, 17 Oct 2024 18:38:07 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <704894.1729194519.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 17 Oct 2024 15:48:39 -0400
Message-ID: <704895.1729194519@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/704895.1729194519%40sss.pgh.pa.us>
Precedence: bulk

"Wong, Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com> writes:
> I have a simple question for "access rights" view or table within Postgr=
es.
> Here is my grant query:

> GRANT USAGE ON SCHEMA abc TO abc_user;
> GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA abc TO abc_=
user;
> GRANT ALL ON ALL SEQUENCES IN SCHEMA abc TO abc_user;
> GRANT EXECUTE ON ALL ROUTINES IN SCHEMA abc TO abc_user;

> But I can't find a view/table that is associated with the above
> grants?

Those commands would simply apply the grants to any existing objects
in the given schema, so you'd have to look at such objects to see
the effects.  If there are none, nothing happens.

You might be looking for ALTER DEFAULT PRIVILEGES?

			regards, tom lane