Re: [EXT] Re: 101 Grants and Access Right Table/View - Mailing list pgsql-admin

From Tom Lane
Subject Re: [EXT] Re: 101 Grants and Access Right Table/View
Date
Msg-id 717065.1729199849@sss.pgh.pa.us
Whole thread Raw
In response to RE: [EXT] Re: 101 Grants and Access Right Table/View  ("Wong, Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com>)
List pgsql-admin
"Wong, Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com> writes:
> These are existing objects/tables.  So I assume after the grants were run,  the  information_schema.role_table_grants
andinformation_schema.usage_privileges shouldn't be blank right/now rows return? 

Maybe.  I believe both of those views will only show information about
grants where you (the user reading the view) are grantor or grantee.
You've not provided any details about your test setup ...

            regards, tom lane



pgsql-admin by date:

Previous
From: "Wong, Kam Fook (TR Technology)"
Date:
Subject: RE: [EXT] Re: 101 Grants and Access Right Table/View
Next
From: Achilleas Mantzios - cloud
Date:
Subject: Migrating from 10 -> 16, PreparedStatements disabled in JDBC and pgbouncer, I am getting : bind /C_5