If you don’t have access to a live PostgreSQL installation at the moment we still have your back.

Reference pointing to the official PostgreSQL documentation.Sending your feedback to shows how to do the following at the psql prompt: If you have any complaints or suggestions please let me know by Well written and thorough, but frankly, I didn’t know where to start reading. The PostgreSQL documentation is incredibly

View on GitHub Pages or directly on GitHub What database administration tasks, but aren’t familiar with how to I assume you’re familiar with the command line and have a rough idea about Quick reference for the absolute least you need to know about psql. Uses psql and you want to learn the absolute minimum to Now what? I assume you’ve been given a task that Maybe this is the reason? But I'd still expect Postgres to give some kind of error when running REVOKE ALL ON SCHEMA public FROM PUBLIC as the editor (it does, when I try to run this as the luser user).Postgres psql command line tutorial and cheat sheet Owner of the schema (so you can check that as well). How can this happen?įrom how do you revoke create table from a user on postgresql 9.4? :Īlso note the user/role executing the revoke also needs to be the So, even though I can run REVOKE ALL ON SCHEMA public FROM PUBLIC as the editor and it doesn't give any errors, luser can still create a table under the public schema. Public | test | table | luser | 0 bytes | Postgres=> create table public.test (uid integer) # I expect this to fail with `ERROR: permission denied for schema public` but it works somehow! Postgres=> REVOKE ALL ON SCHEMA public FROM PUBLIC luser can create a table under the public schema): postgres=> SET ROLE postgres However, when if I try to run REVOKE ALL ON SCHEMA public FROM PUBLIC as the editor user, this does not work (i.e. Public | test | table | editor | 0 bytes |

Schema | Name | Type | Owner | Size | Description Postgres=> create table public.test (uid integer) ĮRROR: permission denied for schema public Postgres=# GRANT ALL ON SCHEMA public TO editor WITH GRANT OPTION Postgres=# REVOKE ALL ON SCHEMA public FROM PUBLIC When I apply the following as the postgres user, I achieve this: postgres=> select current_user I'd like to make it so that luser (or any other non-superusers) cannot create any tables under the public schema, except editor. Let's say we have two users, luser and editor.

Postgres online database editor