|Subject||Re: [firebird-support] Re: SYSDBA|
> > > Is the original table created with SYSDBA? If so, you're outSure you can do all with it that you like. But you're out of luck
> > > of luck...
> > 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
> > 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?
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 ORACLEWith Firebird, you cannot (yet) assign "dba privileges" to a user.
> user and create, db, tables, etc.. If you then assign dba privileges
> to another user, the other user can then create tables, add columns,
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 thisVia some datapump process.
> 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?
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL