"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