Subject Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)
Author Bryan Cole
On Tue, 2018-12-18 at 17:20 +0100, liviuslivius liviuslivius@... [firebird-support] wrote:

If you try something new better use newest snapshot. There are some fixes

OK, I've built and "make installed" the latest 3.0.5 snapshot. This is a fresh install. I'm seeing the same problem:

[root@bryan bin]# ./fbguard -daemon -forever
[root@bryan bin]# ps -A | grep fbguard
 5447 ?        00:00:00 fbguard
[root@bryan bin]# ps -A | grep firebird
 5448 ?        00:00:00 firebird
[root@bryan bin]# ./isql -user sysdba -pass mydbapassword localhost:employee
Database: localhost:employee, User: SYSDBA
SQL> create user test password 'test' grant admin role;
SQL> commit;
SQL> grant RDB$ADMIN TO USER test;
SQL> commit;
SQL> exit;
[root@bryan bin]# ./isql -user test -pass test -role RDB$ADMIN localhost:employee
Database: localhost:employee, User: TEST
SQL> create user foo password 'foo';
Statement failed, SQLSTATE = 28000
add record error
-no permission for INSERT access to TABLE PLG$SRP_VIEW
CON> from rdb$database;



I set my sysdba password during the install routine and ran the server manually from the install location /usr/local/firebird/bin
I turned off SELinux (just in case...).


Karol Bieniaszewski

Group Leader, Technical Development Group - Teraview Ltd.
Platinum Building, St. John's Innovation Park, Cambridge CB4 0DS, UK.
tel: +44 (0)1223 435386, fax: +44 (0)1223 435382, web: Registered Number: 04126946, VAT Number: 770 8883 84

...preferred document formats: ODF (ISO/IEC 26300:2006), PDF