>----- Original Message -----
>From: Mark Rotteveel mark@lawinegevaar.nl [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@citricos.co.cu
>[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@lawinegevaar.nl
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 |
========
Posted by: "Ismael L. Donis Garcia" <slibre@citricos.co.cu>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment