[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_hba.conf fi

[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_hba.conf f

[ADMIN] Can't drop table (repost)

2001-04-24 Thread Jeremy Buchmann
(This is a repost as I haven't received any answers yet :( ) Hi all, I have a weird situation here...I'm trying to drop a table, but it tells me that "Relation 'xxx' inherits 'mytable'". So I renamed mytable to myoldtable and created a new mytable. Now, the new mytable is missing the field

[ADMIN] Re: Restricting user access to databases

2001-04-24 Thread Tim Frank
Jared, It doesn't jump out at you but if you read the pg_hba.conf help REALLY closely you will find that you can do this: host sameuser 192.168.3.0 255.255.255.0 password Where "sameuser" under the DBNAME allows connection to a database of the same name of the user trying to connect.