On 5/11/18 2:12 μ.μ., pavan95 wrote:
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.
Check out privileges you have given to PUBLIC. Those hold still for all future users.
How this can be stopped? Looking forward to hear from you. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt
