Re: [GENERAL] How does connect privilege works?

2012-08-07 Thread Craig Ringer
On 08/07/2012 11:51 AM, Shridhar Daithankar wrote: testdb2=# revoke connect ON database testdb2 FROM testuser1; REVOKE You can't revoke a permission that isn't set. PostgreSQL doesn't have explicit deny rules, so you can only remove a grant. The documentation on databases doesn't seem to

Re: [GENERAL] How does connect privilege works?

2012-08-07 Thread Albe Laurenz
Shridhar Daithankar wrote: 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?

[GENERAL] How does connect privilege works?

2012-08-06 Thread Shridhar Daithankar
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?