Permission denied for sequece...

From: "Jon Horsman" <horshaq(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Permission denied for sequece...
Date: 2006-08-21 19:03:42
Message-ID: 4f4c2a010608211203j6591249cifc9c0a793183aee@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hey,

I'm in the process of porting an app from MySQL to PostgreSQL and am
pretty new with PostgreSQL and am having permission problems.

First, a little background info.
- The postmaster is set to startup with -i and i'm able to actually
connect without an exception.
- I've added the following lines to the pg_hba.conf files (for testing purposes)
local all all trust
host all all 127.0.0.1 255.255.255.255 trust

I create my db, as follows:
createdb testdb

then i log into psql and run the following
CREATE USER testuser PASSWORD 'default';
GRANT ALL ON DATABASE testdb TO testuser;
GRANT ALL ON [my table names] TO testuser;

In my app i connect to the db with the following, which is run without issue.
connection = DriverManager.getConnection("jdbc:postgresql:testdb",
"testuser", "default");

I then call the following insert
INSERT INTO Property (Name,Value) VALUES ("some name", "some value")

and get the following error

org.postgresql.util.PSQLException: ERROR: permission denied for
sequence property_propertyid_seq

The sql used to create the property table is

CREATE TABLE Property
(PropertyID SERIAL PRIMARY KEY,
Name VARCHAR(64) UNIQUE NOT NULL,
Value VARCHAR(255) NOT NULL);

Can someone tell me what would cause this error message to occur and
suggest ways that i could fix it?

Thanks,

Jon Horsman

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Scott Marlowe 2006-08-21 20:55:02 Re: Permission denied for sequece...
Previous Message student23 2006-08-21 08:06:54 I can't retrieve a scrollable ResultSet from CallableStatement