Subject | RE: [firebird-support] Create user with SYSDBA rights? |
---|---|
Author | Alan McDonald |
Post date | 2007-01-29T08:01:47Z |
> Hi.there is only one SYSDBA on each server - and that's SYSDBA
>
> 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...
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.
>roles are database centric - not server centric. The error message says
> 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...
exactly what the problem is.
Alan
>
> Give me solution, please. Thanks
>