Subject Re: [firebird-support] conect flamerobin with Firebird3
Author Ismael L. Donis Garcia
>----- Original Message -----
>From: Mark Rotteveel mark@... [firebird-support]
>To: firebird-support@yahoogroups.com
>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.
>

precisely that.

>> 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.

the user who creates the database, which is the same with which I am trying
to connect, but also comes with other users who have permissions to other
roles created through

>> *** 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@...

This problem does not occur in firebird 2.5.x

there any way to solve this error, or an issue introduced in firebird3?

Best Regards
========
| ISMAEL |
========