Subject Re: [firebird-support] Some issues in Windows Vista
Author Carlos H. Cantu (TeamFB)
AFAIR, you can easily "remove" the SYSDBA role using a Hex Editor.
Some people even say that you don't need hex editor, notepad would by
fine...

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

HB> At 09:08 AM 31/01/2007, you wrote:
>> I'm moving an application to Windows Vista.
>>
>> After installing the application, it runs though there are some errors
>>that I need to track down(minor errors I would say).
>>
>> The application connects to c:\Data\thedata.gdb with the userId and
>>password:
>>
>> appUser/XXXXXXXX
>>
>> Trying to Register c:\Data\thedata.gdb with IBOConsole under
>>appUser/XXXXXXXX credentials, I get:
>>
>>ISC ERROR CODE: 335544745
>>ISC ERROR MESSAGE:
>>
>>Your login SYSDBA is same as one of the SQL role name. Ask your database
>>administrator to set up a valid Firebird login.
>>
>> when using SYSDBA/masterkey as credentials I get:
>>
>>ISC ERROR CODE: 335544745
>>ISC ERROR MESSAGE:
>>
>>Your login SYSDBA is same as one of the SQL role name. Ask your database
>>administrator to set up a valid Firebird login.
>> Have anyone any idea what's is wrong ?

HB> It appears that you have created a role in your database privileges
HB> that has the name 'SYSDBA'. If so, then you have a big problem now,
HB> because you have disabled the *user* SYSDBA from accessing the database.

HB> Ordinary users will still be able to connect. However, you now have
HB> no user that can back up that database.

HB> ./heLen