At 06:32 PM 29/01/2007, you wrote:

>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...
>
>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...
>
>Give me solution, please. Thanks

The solution is not there. No user has all of the rights that the
SYSDBA has. I think what you want to do is create an admin type of
user that you will use as the login when you create a database. (See
my example from an earlier thread today, in the thread with the
subject "Re: CREATE DATABASE". )

Login as this user also when you add metadata objects (via scripts,
or an application) and when you back up and restore that
database; also when you create roles and privileges.

This user will then be the Owner and will have almost all of the same
privileges as the SYSDBA. A database Owner cannot create user
accounts on the server, however. This is strictly for the SYSDBA.

./heLen