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

Sure you can do all with it that you like. But you're out of luck
if you don't have access to account SYSDBA, like in your case.

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

With Firebird, you cannot (yet) assign "dba privileges" to a user.
Now, this is not really a bug, but it's not really helpful either. The
current privileges system is under revision though...

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

Via some datapump process.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com