| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Wong, Kam Fook (TR Technology)" <kamfook(dot)wong(at)thomsonreuters(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [EXT] Re: 101 Grants and Access Right Table/View |
| Date: | 2024-10-17 21:17:29 |
| Message-ID: | 717065.1729199849@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Wong, Kam Fook (TR Technology)" <kamfook(dot)wong(at)thomsonreuters(dot)com> writes:
> These are existing objects/tables. So I assume after the grants were run, the information_schema.role_table_grants and information_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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios - cloud | 2024-10-18 10:11:28 | Migrating from 10 -> 16, PreparedStatements disabled in JDBC and pgbouncer, I am getting : bind <unnamed>/C_5 |
| Previous Message | Wong, Kam Fook (TR Technology) | 2024-10-17 21:09:01 | RE: [EXT] Re: 101 Grants and Access Right Table/View |