Subject Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)
Author Mark Rotteveel
On 2018-12-18 12:12, Dimitry Sibiryakov sd@...
[firebird-support] wrote:
> 18.12.2018 12:04, 'Bryan Cole' bryan.cole@...
> [firebird-support] wrote:
>> [mypc]$ isql-fb -u test -p test -r rdb$admin localhost:mydatabase
>> Database: localhost:mydatabase, User: TEST
> At first, role rdb$admin wasn't granted to this user and applied
> how you can see in
> second quoted line.
> At second, grants are per-database, so the role must be granted in
> the database that
> keeps list of users.

Using CREATE USER ... GRANT ADMIN ROLE, will grant the created user
admin rights in the security database, which is what should be
sufficient here.

I wonder if this might be related to CORE-5898 (fixed in 3.0.4).