Subject RE: [firebird-support] Create user with SYSDBA rights?
Author Alan McDonald
> Hi.
>
> I want to create dinamic a user, using INTERBASE component, with all
> tehe SYSDBA rights....and after that i want to make a backup of
> database using tis user...

there is only one SYSDBA on each server - and that's SYSDBA
you must first create a user THEN create your database (and the objects in
the database) with that user for that user to be able to backup/restore the
database.

>
> I create a role with all the rigts, give the make the new user membre
> of this role...but if i weant to backup or retore
> databese ...error...You must be eighter SYSDBA or owner of the
> database...

roles are database centric - not server centric. The error message says
exactly what the problem is.
Alan

>
> Give me solution, please. Thanks
>