Thanks, I`ll do that.

Mercea Paul wrote:

>
> Simplest way is to log in into yout tool (IBExpert,DBWorkbench) with your
> user an create an empty database.That user will be owner of database.
> After
> that you could use DataPump to migrate your data, or simple extract
> metatdata and run that script in your new database.
>
> Regards,
>
> Paul
>
> From: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> [mailto:firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>] On Behalf Of Cornel Rebegea
> Sent: Tuesday, March 13, 2007 12:56 PM
> To: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> Subject: Re: [firebird-support] change masterkey password or leave
>
> Hi, Mersi de raspuns.
> About the owner. How do you change the owner of the database.
> I have found a script that works on system tables that seems to be ok
> until I try to do back-up/restore. The restored database does not grant
> my user acces to the stored procedures.
> Changing the owner via backup - restore wasn`t succesful either. Just
> point me to the right direction.
> Thanks.
>
> Mercea Paul wrote:
> >
> > Hi Cornel,
> >
> > Best practice suggest to change it! You can use other user for your
> > database, make sure it's the owner if you want to make back-up restore
> > without using SYSDBA account!
> >
> > Regards,
> >
> > Paul
> >
> > From: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> <mailto:firebird-support%40yahoogroups.com>
> > <mailto:firebird-support%40yahoogroups.com>
> > [mailto:firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> <mailto:firebird-support%40yahoogroups.com>
> > <mailto:firebird-support%40yahoogroups.com>] On Behalf Of Cornel Rebegea
> > Sent: Tuesday, March 13, 2007 12:17 PM
> > To: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> <mailto:firebird-support%40yahoogroups.com>
> > <mailto:firebird-support%40yahoogroups.com>
> > Subject: [firebird-support] change masterkey password or leave
> >
> > Hi,
> > I come to bother you with another question.
> > I am working on a shrinkwrapped application with Delphi on firebird.
> > What is the recommended practice on dealing with admin password (leave
> > masterkey or change), use a limited generic user (i.e. AppUser),
> > considering I need an easy and seamless integration on clients systems?
> >
> > [Non-text portions of this message have been removed]
> >
> >
> > ----------------------------------------------------------
> >
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.413 / Virus Database: 268.18.10/720 - Release Date:
> 3/12/2007
> >
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.413 / Virus Database: 268.18.10/720 - Release Date: 3/12/2007
>

[Non-text portions of this message have been removed]