Re: [PERFORM] Schema vs Independant Databases, ACLS,Overhead,pg_hba.conf

2006-02-25 Thread Alvaro Herrera
Eric Lauzon wrote: Hi, > Now that the issue is that we can't implement a per connection user/ACL > pair , would it be a good idea to implement > Schema ACLS and mabey pg_hba.conf Schema acls This is certainly possible to do using GRANT and REVOKE on the schemas; no need to fool with pg_hba.con

[PERFORM] Schema vs Independant Databases, ACLS,Overhead,pg_hba.conf

2006-02-24 Thread Eric Lauzon
Hello all, I have this small set of questions that i have been looking to ask and here it comes. Lets imagin we have a setup where we have multiple databases instances on one server, and we are starting to use more and more cross databases queries [query unions] using dblink [multiple context but