1

I've a PostgreSQL Server with 5 db and 2 users: postgres and forge, both with Superuser attribute.

I want to create a third user that can only see and use one and just one of the db and by using it I mean only perform select.
I've tried different solutions but seems that the brand new user can access to all the other dbs.

Thank you

Improve this question
1
  • I've created a user with CREATE USER newuser WITH ENCRYPTED PASSWORD 'newpassword' then GRANT connect ON DATABASE database_name TO newuser then GRANT SELECT ON ALL TABLES IN SHEMA public TO newuser
    – Fed03
    Commented Mar 26, 2015 at 11:04

0

Reset to default

Browse other questions tagged or ask your own question.