From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: How to revoke "Create Privilege" from a readonly user in postgres?
Date: Mon, 5 Nov 2018 05:12:44 -0700 (MST)
Message-ID: <1541419964128-0.post@n3.nabble.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pavan.postgresdba@gmail.com
Subject: Re: How to revoke "Create Privilege" from a readonly user in postgres?
In-Reply-To: <1541419964128-0.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox