|Subject||Re: [firebird-support] Re: SYSDBA|
> Log into the database with isql, as SYSDBA. Do a metadata extract usingFYI: All these steps can be performed using DBak. Access the
> isql and output it to a file. That will give you a full script for
> reconstructing the database. Log out of isql; then log in again as your
> ADMIN user, without connecting to a database.
> Edit the script to remove any GRANT statements pertaining to the ADMIN user
> (that your host's SYSDBA added previously). Retain any that pertain to
> PUBLIC, to roles or to ordinary users.
> Run your metadata script to recreate your database (into some other
> location, natch!!). You should now have an empty database, of the same
> structure as the original, but now ADMIN is the Owner of both the database
> and the objects in it.
> Next, pump the data from the original database. There are various tools
> around for doing this, e.g. the IBPump tool from www.clevercomponents.com
> or the very handy datapump tool in IB_SQL (free from
> www.ibobjects.com). You will need to log into the original database as
> SYSDBA (in case there are other deficient privileges you don't know about)
> and you can log into the new database as either SYSDBA or ADMIN (i.e. owner).
source as SYSDBA, access the backup/rebuild as the new user.
Not trying to do a hard sell (its free), but is MUCH easier
because DBak takes care of metadata statement order issues.
I had always considered it a limitation of DBak that it cannot
transfer ownership details on the new database, but in this
situation it is a "feature". :-)
The rest of Helen's instructions remain necessary.