Re: How to revoke "Create Privilege" from a readonly user in postgres?

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to revoke "Create Privilege" from a readonly user in postgres?
Date: 2018-11-05 12:12:44
Message-ID: 1541419964128-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I want to know if there is anyway to disallow a user from creating his own
tables.
He should be only provided with the "SELECT" access apart from that no other
access should be available with him.

I have created a user "readonly" with no other privilege other select on
database "abc". But when I tried to connect as "readonly" he is given with
"SELECT" privilege but the problem here is he was also be able to create his
own tables in the database.

How this can be stopped? Looking forward to hear from you.

Regards,
Pavan

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2018-11-05 12:32:35 Re: How to revoke "Create Privilege" from a readonly user in postgres?
Previous Message Achilleas Mantzios 2018-11-05 11:24:00 PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint