Subject | Re: Create user has privileges as SYSDBA |
---|---|
Author | alanpltse |
Post date | 2007-01-24T12:06:55Z |
Thanks for your info.
My problem is I got a Firebird database file from a machine 'A'.
Then copy/paste this file to machine 'B', in this case who will be the
database owner? Can I change the ownership?
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:
My problem is I got a Firebird database file from a machine 'A'.
Then copy/paste this file to machine 'B', in this case who will be the
database owner? Can I change the ownership?
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:
>
> Hi,
>
> > I want to create a user has the similar privileges as SYSDBA, how can
> > I do that?
>
> You cannot. SYSDBA can do everything, no other user can.
>
> > I tried to backup the database using a newly created user but an error
> > said that the user does not have enough permission to do that.
>
> Databases can be backed up by SYSDBA or the database owner
> (which is the user that created the database).
>
> Martijn Tonies
> Database Workbench - development tool for Firebird and more!
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>