--- In firebird-support@yahoogroups.com, "rstupidguy"
<rstupidguy@y...> wrote:

>
> --- 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...

I still dont know what the problem is and think its verry strange.
Maybe it's got something to do with what helebor wrote but I don't
have the problem anymore!
I tried extracting metadata with IBExpert and generated a new
database using the scrip. Its a workaround and I m still curious
about the problem but I got my database working again.
link to the working sql:
http://members.home.nl/francoismeijerink/creatSQL.sql