Hi to all, i've seen this is a popular topic but haven't found any concrete answers so far. So my scenario is this :
- created a new user with : sudo -u postgres createuser -D -A -P john - created a new database with : sudo -u postgres createdb -E 'UTF8' -O john test - added plpgsql sudo -u postgres createlang plpgsql test After that i wanted to allow "external" access to the "test" database. So i tried configuring the pg_hba.conf file. In my first attempt i added this line to pg_hba.conf: host all john 0.0.0.0/0 md5 And john had connect access to access to all databases and admin access to his "test" database. After that i wanted give john admin access to his "test" db, and absolutely no access to other databases. host test john 0.0.0.0/0 md5 It doesnt work. Can't login through pg_admin. I've played with revoking access to other databases, but to no avail. I'm quite positive i'm not the first one with this issue. There is a similar http://postgresql.1045698.n5.nabble.com/Extended-security-restriction-to-any-role-with-login-access-td2089118.html#a2089128 thread on the matter.. Any help would be very appreciated. -- View this message in context: http://postgresql.1045698.n5.nabble.com/managing-access-to-database-tp3276689p3276689.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin