Receiving error: "Your SYSDBA login is the same as one of the SQL role name" when trying to access base with IBExpert

Question

Receiving error: "Your SYSDBA login is the same as one of the SQL role name" when trying to access base with IBExpert

Navigation

#1 by (1 votes)
#2 by (0 votes)

5

I need to access data from a firebird database (.FDB), but when trying to access this database using IBExpert I get the following error:

"your SYSDBA login is the same as one of the SQL role name".

In my research, I discovered that this error is a ROLE that was created with the same name as the default firebird user, making it impossible for me to access this database with the default user.

Among the solutions to this problem, I did not succeed with any, but the one I found most plausible would be to directly edit the .FDB via a text editor giving a REPLACE on the SYSDBA instances, but I was also unable to apply this solution even though file being read-only.

Would anyone know of a way to be able to drop this ROLE or bypass it?

NOTE: I have firebird 2.5 installed version 32x on a 64x S.O.

firebird

asked by anonymous 08.12.2014 / 14:45

2 answers

How to pass parameter to a dialog with PrimeFaces? Is there any way to create a moip account by api from moip?

score 1 · Answer 1

Try using the isql.exe that is in the firebird installation directory.

SQL> CONNECT "C:\CAMINHO\NOMEDOBANCO.FDB" 
SQL> user 'SYSDBA' password 'masterkey';

Or you can create a new user and give admin rights to it.

GRANT RDB$ADMIN TO username.

I hope I have helped.

score 0 · Answer 2

0

This application solves the problem easily:

link

Source: link

28.10.2015 / 12:19