On Wed, 2018-12-19 at 13:46 +1300, Helen Borrie hele...@iinet.net.au [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
