It seems that connecting through PG Server one has to be an administrator.
The reason is that PG Server automatically tries execute command
SET MODE POSTGRESQL.
(See: org.h2.engine.Engine:180)
And as the documentation states admin privileges are needed for this operation.
This started me thinking is the MODE database wide?
Because only then the requirement for admin privileges makes any sense.
And if it is database wide it is very limiting because I certainly do not wish that my other application stops working when some other client connects through
the PG Server.
Anyway, the bottomline is that only admin users can connect through the PG
Server.
- rami
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
