[ADMIN] Restricting user access to databases

2001-04-23 Thread Jared Sulem
Is there anyway to make PostgreSQL automatically only grant access to databases by their owners, and preferably database superusers, rather than making lots of pg_hba.conf entries and password files? It would be nice if there was an option to do this, so then pg_hba.conf would only need editin

[ADMIN] Re: Restricting user access to databases

2001-04-24 Thread Jared Sulem
Jared Sulem wrote: > Is there anyway to make PostgreSQL automatically only grant access to > databases by their owners, and preferably database superusers, rather > than making lots of pg_hba.conf entries and password files? Just had an idea. Another token could be added to the pg

[ADMIN] Re: Restricting user access to databases

2001-04-24 Thread Jared Sulem
Jared Sulem wrote: > Is there anyway to make PostgreSQL automatically only grant access to > databases by their owners, and preferably database superusers, rather > than making lots of pg_hba.conf entries and password files? Just had an idea. Another token could be added to the pg

Re: [ADMIN] Remote login to the database

2001-04-25 Thread Jared Sulem
vijayendra mohan agrawal wrote: > how do I connect to the database. psql -h host [-p port] [-U username] database_name OR psql -h host [-p port] database_name username psql --help for details of all the options. One thing to remember - if you try to login from the database machine and if yo