Thread: Permission denied error with testGetUDTQualified

Permission denied error with testGetUDTQualified

From
Xavier Poinsard
Date:
Hi,
Trying to run the tests from Build 308 againt a 7.4.1 server I got the
following error :

  [junit] Testcase:
testGetUDTQualified(org.postgresql.test.jdbc2.DatabaseMetaDataTest):
   Caused an ERROR
     [junit] ERROR: permission denied for database test
     [junit] java.sql.SQLException: ERROR: permission denied for
database test
     [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1356)
     [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1151)
     [junit]     at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:166)
     [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:363)
     [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:293)
     [junit]     at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:285)
     [junit]     at
org.postgresql.test.jdbc2.DatabaseMetaDataTest.testGetUDTQualified(DatabaseMetaDataTest.java:503)

Can someone provides the way to solve this error (and add a note in the
code) ?
Thanks.

Re: Permission denied error with testGetUDTQualified

From
Kris Jurka
Date:

On Wed, 17 Nov 2004, Xavier Poinsard wrote:

> Trying to run the tests from Build 308 againt a 7.4.1 server I got the
> following error :
>
>   [junit] Testcase:
> testGetUDTQualified(org.postgresql.test.jdbc2.DatabaseMetaDataTest):
>    Caused an ERROR
>      [junit] ERROR: permission denied for database test
>      [junit] java.sql.SQLException: ERROR: permission denied for
> database test
>
> Can someone provides the way to solve this error (and add a note in the
> code) ?

The code is trying to create a schema, which you apparently don't have
permission to do.

GRANT CREATE ON DATABASE test TO test;

should fix this.  Making test the owner of the test database, or making
test a superuser will also make this work.

Kris Jurka

Re: Permission denied error with testGetUDTQualified

From
Oliver Jowett
Date:
Xavier Poinsard wrote:

>  [junit] Testcase:
> testGetUDTQualified(org.postgresql.test.jdbc2.DatabaseMetaDataTest):
> Caused an ERROR
>     [junit] ERROR: permission denied for database test

The test user must own the test database. See
http://jdbc.postgresql.org/development/intro.html.

-O