Re: Using the JDBC Driver - users: Permission Denied

Apart from the grant db/table access right to dividual db user, you
have to modify the pg_hba.conf to grant the connection right for
specific IP to access postgresql database.

Before you try to apply the security checking,
try to do the connection with trust(no password required) first.

At the end of the pg_hba.conf, add the following line

host test 192.168.1.0 255.255.255.0 trust

This will make all host with the IP 192.168.1.* to access the "test" db without
password.

Once this is okay, you can replace it with the following line :

host test 192.168.1.0 255.255.255.0 crypt

In order to enable the password checking, you have to enter the passwd for the
account in the "pg_shadow" System table.

List all System table :
\dS

List the content of "pg_shadow":

select * from pg_shadow;
------------+---------
usename | testuser
usesysid | 27
usecreatedb | t
usetrace | f
usesuper | f
usecatupd | f
passwd | test123
valuntil |
------------+---------

Hope this can help you.

peter(at)retep(dot)org(dot)uk (Peter Mount) wrote in
<5(dot)0(dot)2(dot)1(dot)0(dot)20010207221117(dot)00a65e60(at)mail(dot)retep(dot)org(dot)uk>:

>At 10:49 07/02/01 -0800, Hunter Hillegas wrote:
>>I am working on my first PostgreSQL application using Java... I'm
>>previously a mySQL user... I am running 7.1 beta4.
>>
>>Anyway, I got everything installed and to the point that my JSP is
>>trying to access the database...
>>
>>When I try to make the Connection call, I get this error message:
>>
>>java.sql.SQLException: ERROR: users: Permission denied.
>
>Have you granted permission to the account your servlet is connecting
>as?
>
>
>>I created a user called 'test' using the 'createuser' program. I am
>>trying to connect as this user without a password. The servlet engine
>>is on the same machine as the database.
>>
>>I have not modified pg_hba.conf file at all.
>
>Should work...
>
>
>>There must be a permissions thing but I don't know what it is. The
>>database was not created as this user... Is that the problem? If so,
>>how do I change the ownership over to the newer user.
>
>atleast do: GRANT SELECT ON table TO user ;
>
>
>>I looked in Bruce's book but I'm still having trouble.
>>
>>Any help is appreciated. Thanks.
>>
>>Hunter
>>--
>>Hunter Hillegas
>>hunter(at)lastonepicked(dot)com
>