On Wed, 2018-12-19 at 13:46 +1300, Helen Borrie helebor@... [firebird-support] wrote:

 

Bryan,

Maybe something in here will provide that ah-haa moment. ;-)

<snip>

In Fb 3 and Fb 4-alpha, you must have *both* and perform your login with
the role. In Fb 4 beta 1, a user with the GRANT ADMIN ROLE (SEC$ADMIN TRUE)
does not need to log in with the RDB$ADMIN role. I don't know whether this
is going to be backported to Fb 3.0.5.

Helen

Thanks for the informative post. Turns out my problem was my linux shell mangling the role-name.

I've learned a lot about the Firebird security database in process of tracing this though. Have also aged about 5 years in the last 2 days.

Bryan