--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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

Thanks for the quick reply

Here is one example of dll I used to create a table, its not quoted.
I am using dialect 3 though wich is case sensitive.
[code]
CREATE TABLE BOEKINGEN (
BOEKING_ID ID,
BOEKINGSDATUM DATE NOT NULL,
KLANT_ID ID,
ARRANGEMENT_ID "ID with null",
DEFINITIEF YN DEFAULT 'N',
FACTUUR_ID "ID with null",
GEARRIVEERD YN,
USERNAME NAAM,
AANTALPERSONEN INTEGER);
[/code]

It isnt quoted...