<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=509274415-08022006>Perhaps a kind soul
is willing to help out, on a problem where I seem to be overlooking the obvious
. . . </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=509274415-08022006>I run a
PostgreSQL8.1+PostGIS1.0 installation in a course on spatial databases. My
users, students, have their own accounts and schemas. There is also a
public schema that has USAGE grant for PUBLIC. Students are supposed to
create feature tables in their personal schema, and want to register the
geometry columns in public.geometry_columns. They do so
by:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=509274415-08022006>SELECT
AddGeometryColumn('m6h','tempy','geom',4267,'POLYGON',2);</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=509274415-08022006>where m6h is both
account name and schema name.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=509274415-08022006>The error resulting
is:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=509274415-08022006>Error:
org.postgresql.util.PSQLException: ERROR: permission denied for relation
geometry_columns, SQL State: 42501, Error Code: 0</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=509274415-08022006>The standard answer
to this type of problem is that the user does not have sufficient privileges to
insert into the geometry_columns table, or so I understand. However,
if the same user tries the following:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=509274415-08022006>insert into
public.geometry_columns<BR> values('','m6h','tempy','geom',2,4267,'POLYGON');</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=509274415-08022006>that will just
succeed. Actually the user has been granted SELECT, INSERT privileges on
that table. Can it be that other privileges are in the
way?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=509274415-08022006>I am
stymied,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006>Rolf</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=509274415-08022006></SPAN></FONT> </DIV></BODY></HTML>