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

Asked

Viewed 3,382 times

5

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

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

In researches I performed, I found that this error is a ROLE that was created with the same name of the default user of Firebird, making it impossible for me to access this base with the default user.

Among the solutions to this problem, I did not succeed with any, but the one I found more plausible would be to directly edit the . FDB via some text editor giving an REPLACE in the occurrences of SYSDBA, but also I could not apply this solution even the file with 'read only' unchecked.

Would anyone know a way to drop this ROLE or get around it?

NOTE: I have Firebird 2.5 installed version 32x in a S.O. 64x.

firebird

  • It remained to explain which solutions you tried and failed.

2 answers

1

Try using the isql.exe 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’ve helped.

0

Browser other questions tagged firebird

You are not signed in. Login or sign up in order to post.