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

Fed03
  • 111
  • 2
  • 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 Mar 26 '15 at 11:04

0 Answers0