Postgres Pro
Downloads
Home   >   mailing lists

JDBC update permission denied!!! - Mailing list pgsql-interfaces

From Bernhard Matthias Ertl
Subject JDBC update permission denied!!!
Date
Msg-id Pine.HPP.3.95q.980608234110.214A-200000@delos.dbs.informatik.uni-muenchen.de
Whole thread Raw
In response to pgaccess under IRIX 5.3 - please help  (Stuart Rison <stuart@ludwig.ucl.ac.uk>)
Responses Re: [INTERFACES] JDBC update permission denied!!!  (Peter T Mount <pgint@maidast.demon.co.uk>)
List pgsql-interfaces
Tree view 
Hi all, I hope only a small problem: When I'm connecting via JDBC to my
database, I can select without any problems, but updating I get permission
denied, and no action is performed. Maybe it is, cause I'm connecting from
a applet via TCP/IP. In the pga_access the host and also the server are
trusted.....
So, what could I do?

Be
*********************************************************************
* Bernhard Matthias Ertl  *  email: ertl@bigfoot.com                *
* Calslaan 1-107          *                                         *
* NL-7522 MH Enschede     *         ertl@edupsy.uni-muenchen.de     *
* Tel: ++31 53 489 5001   *                                         *
*********************************************************************
select * from ID where kind = 'node'
update ID set ID = 16 where kind = 'node'
Exception: java.sql.SQLException: WARN:id: Permission denied.

pgsql-interfaces by date:

Previous
From: Tim Bosinius
Date:
Subject: Website for PostgreSQL Win Access
Next
From: Peter T Mount
Date:
Subject: Re: [INTERFACES] JDBC update permission denied!!!