REVOKE SELECT column on FOREIGN TABLE

From: Samuel Inman <Samuel(dot)Inman(at)atento(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: REVOKE SELECT column on FOREIGN TABLE
Date: 2017-01-05 00:04:13
Message-ID: etPan.586d8d7d.71b70254.155@atento.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I’m running the following command:
REVOKE SELECT(column_name) ON TABLE table_name FROM role;
And I get “REVOKE” echoed back to me, but the table’s permissions do not reflect the change, and the role can still select that column.
Does the REVOKE command not work at the column level for foreign tables?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2017-01-05 04:16:14 Re: REVOKE SELECT column on FOREIGN TABLE
Previous Message Tom Lane 2017-01-04 18:50:11 Re: server log error on startup