|
Hello,
I am trying to setup a cluster for trac databases and want to isolate each db, by assigning a specific user to a DB.
I followed the documentation but as shown in the following example, limiting access by connect does not seem to be working.
What am I missing?
------------ shridhar@bheem ~$ createuser testuser1 Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) y Shall the new role be allowed to create more new roles? (y/n) y
shridhar@bheem ~$ createdb -O testuser1 testdb1
shridhar@bheem ~$ createdb testdb2
shridhar@bheem ~$ psql testdb2 psql (9.1.4) Type "help" for help.
testdb2=# revoke connect ON database testdb2 FROM testuser1; REVOKE testdb2=# \q shridhar@bheem ~$ psql -U testuser1 testdb2 psql (9.1.4) Type "help" for help.
testdb2=> \q
shridhar@bheem ~$ psql test psql (9.1.4) Type "help" for help.
test=# select version(); version --------------------------------------------------------------------------------------------------------- PostgreSQL 9.1.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.7.0 20120505 (prerelease), 64-bit (1 row)
------------ -- Regards Shridhar |
