Hello seems like my mail to pgsql-novice is being ignored so I'll try here. How can I let local users connect with their own ID locally without having to enter a password, but disallow them to reconnect - with \connect - as another user - either completely or allow it only using a password. Right now everybody connected localy can use "\connect database postgres" and become the postgres super-user (or any other user). Second question: how can I prevent users from creating tables in other databases beside their own (or a set of specified databases). Something like `grant create table on database to somebody'. Using PostreSQL 6.3.2 on Linux. tia, Andi PS: A pointer to the documentation is also welcome, I couldn't find it anywhere.
