Re: [GENERAL] Restrict access

2007-08-04 Thread Michael Knudsen
On Aug 2, 4:08 pm, Michael Knudsen [EMAIL PROTECTED] wrote: I can't find a file with that name. I am not using postgreSQL on my own computer, so the file may be hidden somewhere in a directory which I haven't got access to. Is there another way to get rid of 'trust'? Finally, I have managed

Re: [GENERAL] Restrict access

2007-08-04 Thread Michael Knudsen
On Aug 2, 3:51 pm, Adam Witney [EMAIL PROTECTED] wrote: Take a look at the pg_hba.conf in the PGDATA directory, you probably have the connection set to 'trust'... Which won't require a password from that connection location/type. You will need to run a pg_ctl reload to make any changes take

[GENERAL] Restrict access

2007-08-04 Thread Michael Knudsen
Hi, I have created a database and imported a lot of data. I would like to share this database with other people but they should not be able to change anything. That is, they should only be allowed to use the SELECT command. If I create a user, this user can access the database and see the names

Re: [GENERAL] Restrict access

2007-08-04 Thread Peter Eisentraut
Michael Knudsen wrote: I can't find a file with that name. I am not using postgreSQL on my own computer, so the file may be hidden somewhere in a directory which I haven't got access to. Is there another way to get rid of 'trust'? No. -- Peter Eisentraut

Re: [GENERAL] Restrict access

2007-08-02 Thread Adam Witney
On 2/8/07 13:35, in article [EMAIL PROTECTED], Michael Knudsen [EMAIL PROTECTED] wrote: Hi, I have created a database and imported a lot of data. I would like to share this database with other people but they should not be able to change anything. That is, they should only be allowed to