Revoke SQL doesn't take effect

From: Jason W <jsonw(at)protonmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Revoke SQL doesn't take effect
Date: 2019-01-29 20:49:23
Message-ID: ecC6986C1d5wx6oZFYbFUzKhMeIhxFbyU83q26lUSTVaLyQzGFbwjuv6O_sxwePcdXeh9E-Swykw0bt2HWKgYnNqGwpWK8dbw5uaR1Nco3Q=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have two postgresql accounts created by someone else who I do not know (So I do not know setting for those accounts and tables created). One is read only account e.g. read_only_user (This can perform select operations only). The other is admin account e.g. admin_user (This can perform grant, revoke, CRUD, and so on operations).

The read only account can query (select sql) a table (suppose it's called table1) under a specific schema (suppose it's schema1). For instance select * from schema1.table1. Now I received a request to revoke select for that read only account on table1. So I execute

revoke select on schema1.table1 from read_only_user

psql returns REVOKE string (or something similar showing the sql execution was successful) on console. However, when check with read_only_user account. I am still able to query table1. Searching the internet, [1] looks like the closest to my problem. But I do not find solution in that thread.

So my question:
What steps do I need to perform in order to exactly revoke select from read only user account for a particular table? So the read only user account wont' be able query that specific table with select permission revoke (psql should returns info like permission denied).

Thanks

[1]. https://www.postgresql.org/message-id/00ce01cbef04%24910606b0%24b3121410%24%40yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Viktor Berke 2019-01-29 21:11:22 User Name Maps seem broken in 11.1 on CentOS 7
Previous Message Rene Romero Benavides 2019-01-29 18:47:45 Re: Table Replication