Subject Re: [firebird-support] conect flamerobin with Firebird3
Author Ismael L. Donis Garcia
Post date 2016-04-26T15:15:49Z

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 -----
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' slibre@...
[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 <mark@...>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)