How do I prevent roles from table creation in Postgres?

6th_sense · 03-17-2016, 11:11 PM

I'm running Postgres 9.3, and I was wondering:

I wish to create a database role that isn't allowed to create/alter tables in the database which the role is allowed to access. But, it should be able to query, search and insert data.

Is that possible?

The official documentation goes as far as listing createdb priviledges, but I didn't see the portion that describes this level of access control that I am looking for.

Let me know if it is not possible to actually create such a role.

tshikose · 03-18-2016, 03:52 AM

Hi,

Maybe try the following.
1. create a role that has SELECT and INSERT rights on tables, but not UPDATE.
2. then assign that role to the role that on which you wanted to limit the rights.

I have not tried it, as I do not have a Postgresql box to work on now.

Regards,