Re: Using the JDBC Driver - users: Permission Denied

Поиск
Список
Период
Сортировка
От Peter Mount
Тема Re: Using the JDBC Driver - users: Permission Denied
Дата
Msg-id 5.0.2.1.0.20010207221117.00a65e60@mail.retep.org.uk
обсуждение исходный текст
Ответ на Using the JDBC Driver - users: Permission Denied  (Hunter Hillegas <hunter@lastonepicked.com>)
Ответы Re: Using the JDBC Driver - users: Permission Denied  (Hunter Hillegas <hunter@lastonepicked.com>)
Список pgsql-general
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@lastonepicked.com


В списке pgsql-general по дате отправления:

Предыдущее
От: elwood@agouros.de (Konstantinos Agouros)
Дата:
Сообщение: Import Performance
Следующее
От: Hunter Hillegas
Дата:
Сообщение: Re: Using the JDBC Driver - users: Permission Denied