[ome-users] icegridnode: failure occurred in daemon

josh.moore at gmx.de josh.moore at gmx.de
Tue Jun 30 16:45:07 BST 2009


Bernhard Holländer writes:
 > Hi Yves and Josh!

Hi Bernhard,
 
 > I just wanted to mention that the login ability is not enough. If the
 > seq_table is not owned by the user you are using to connect to the db,
 > you will still get an "permission denied" exception. I recently have
 > seen this, when migration some test db owned by a different user to
 > another db user account. You should try the following to verify the
 > accessibility:
 > psql -h YOURDBHOST -U YOURDBUSER YOURDBNAME -c "select * from seq_table;"
 > 
 > Cheers! Bernhard

$ psql -h localhost -U t omero4.0 -c "select * from image"
ERROR:  permission denied for relation image

The same holds true for any relation in the db, but seq_table is
accessed before most others. One way or the other, you're very right
that the test should be extended. Thanks for pointing it out!

~Josh.



More information about the ome-users mailing list