Postgres Pro
Downloads
Home   >   mailing lists

Create Read only user - Mailing list pgsql-admin

From Yambu
Subject Create Read only user
Date
Msg-id CALhHtcA5CYQU0SLU673qAdZiixAJJ8GF2ZEJV7YSiq03h5W-jw@mail.gmail.com
Whole thread Raw
Responses Re: Create Read only user
Re: Create Read only user
List pgsql-admin
Tree view
Hello

I created a user like this 

CREATE USER user1 WITH PASSWORD '<password>';

GRANT CONNECT ON DATABASE db1 TO user1;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO user1;

What amazes me is that when I connect using user1, I'm able to create a table and drop it. How can this be?



pgsql-admin by date:

Previous
From: Stéphane KANSCHINE
Date:
Subject: Re: Regarding 500 Internal Server Error
Next
From: Rohit Rajput
Date:
Subject: Re: Create Read only user