Subject Creating Firebird 3 database using TIBORestoreService does not pass ROLE ( Think )
Author

Trying to create/restore a backup in Firebird 3. failing miserably.


I get:

no permission for CREATE access to DATABASE


  IBORestoreService.Params.Add('user_name=MYUSER');

  IBORestoreService.Params.Add('password=MYPASSWORD');

  IBORestoreService.Params.Add('sql_role_name=RDB$ADMIN');


Any Idea why?


This works via command line though:


"D:\Program Files (x86)\Firebird\Firebird_3_0\gbak.exe" -C D:\Testsystems\Customer\data\op.fbk D:\Testsystems\Customer\data\op.fdb -role RDB$ADMIN



Kind Regards,



Robert Gilland.