From: | Peter T Mount <pgint(at)maidast(dot)demon(dot)co(dot)uk> |
---|---|
To: | Bernhard Matthias Ertl <ertl(at)delos(dot)dbs(dot)informatik(dot)uni-muenchen(dot)de> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: [INTERFACES] JDBC update permission denied!!! |
Date: | 1998-06-09 05:57:34 |
Message-ID: | Pine.LNX.3.95.980609065530.19890A-100000@retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Mon, 8 Jun 1998, Bernhard Matthias Ertl wrote:
> 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.....
No, applet security doesn't filter down to the database. The fact that you
are connecting to the database means that Applet Security isn't affecting
you.
> So, what could I do?
Did you create the tables as a different user to the one the applet is
using? If so, you will have to GRANT update access to the applet user for
them to update the tables.
--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Jose' Soares Da Silva | 1998-06-09 10:18:08 | M$-Access'97 and TIMESTAMPs |
Previous Message | Bernhard Matthias Ertl | 1998-06-08 21:47:14 | JDBC update permission denied!!! |