At 12:44 PM 7/02/2005 +0000, you wrote:

>I just joined this group in the hope someone can get me going again
>on a strange problem I'm stuck on.
>
>The problem:
>If I create a user for my database and grant him rights (all) to all
>(data) tables and try to connect to a table I get the message 204
>table unknown. If I grant rights to this user for the systemtables I
>wont get any error and it ll just function normally.

My first guess here is that you created your tables with quoted identifiers
(some tools do this for you by default if you don't tell them not
to). Once you create identifiers with quotes, you are stuck with using
them for everything - including privileges.

The system tables do not have quoted identifiers. Like any regular
database objects without quoted identifiers, their names are case
insensitive (stored in upper case and can be referred to in lower or mixed
case).

./hb