No I have not registered the dabtabase with the sysdba user. Even as I say connect and put the user who believes the database and gives me the same error as if flamerobin not respect the user with which I want to connect. This error does not occur in version 2.5.5 because the db is a restored from a dabtabase running perfectly firebird 2.5.5 with the sysdba role created and another user as the owner of the dabtabase.
Regards.. ======== | ISMAEL | ======== ----- Original Message ----- From: Mark Rotteveel [email protected] [firebird-support] To: [email protected] Sent: Tuesday, April 26, 2016 9:38 AM Subject: Re: [firebird-support] conect flamerobin with Firebird3 On 2016-04-26 14:10, 'Ismael L. Donis Garcia' [email protected] [firebird-support] wrote: > Create a firebird 3 bd in another user who is not sysdba > and create a role called sysdba without permission Creating a role called SYSDBA will disallow the user SYSDBA to connect to Firebird. > and when I try to connect from flamerobin you give me the following > error message What user? Given the error below I suspect you are connecting with SYSDBA. > *** IBPP::SQLException *** > Context: Database::Connect > Message: isc_attach_database failed > > SQL Message : -902 > Unsuccessful execution caused by a system error that precludes > successful execution of subsequent statements > > Engine Code : 335544745 > Engine Message : > Your login SYSDBA is same as one of the SQL role name. Ask your > database administrator to set up a valid Firebird login. > unknown ISC error 335545081 > > As I can overcome this error? Dont create / drop the role SYSDBA. Mark Posted by: Mark Rotteveel <[email protected]> Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)
