--- In firebird-support@yahoogroups.com, "Si Carter" <simon.carter@t..
.> wrote:

>
>
> > -----Original Message-----
> > Is the original table created with SYSDBA? If so, you're out
> > of luck...

YES.

>
>
> The first rule of firebird club: you don't develop using sysdba
> The second rule of firebird club: YOU DON'T DEVELOP USING SYSDBA
>
> :-)
>
> I've seen this happen on many occasions, there should be an FAQ

regarding

> developing/creating database under SYSDBA account
>

So what is the point of having the SYSDBA user if you can't really do
anything with it?

I've used oracle previously, and when creating a DB you use the ORACLE
user and create, db, tables, etc.. If you then assign dba privileges
to another user, the other user can then create tables, add columns,
etc..

Is this a bug? If so, then I agree there should be a FAQ on this
subject. So if I have to recreate all my tables under this other DBA
equivalent user, how do I export the data from the old db and import
it into the new?

Thanks
David