Subject Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)
Author Bryan Cole
On Wed, 2018-12-19 at 13:46 +1300, Helen Borrie helebor@... [firebird-support] wrote:


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


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.


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.