Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

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. ;-) 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

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS) [SOLVED]

On Tue, 2018-12-18 at 20:04 +0100, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 18.12.2018 19:17, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: [root@bryan bin]# ./isql -user test -pass test -role

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

Bryan, Maybe something in here will provide that ah-haa moment. ;-) C:\Programs64\Firebird_3_0_embedded>isql employee -user sysdba Database: employee, User: SYSDBA SQL> show version; ISQL Version: WI-V3.0.4.33054 Firebird 3.0 Server version: Firebird/Windows/AMD/Intel/x64 (access method),

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

18.12.2018 19:17, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: > [root@bryan bin]# ./isql -user test -pass test -role > RDB$ADMIN > localhost:employee Didn't you forget about a special meaning of $ in bash command line? -- WBR, SD.

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 17:20 +0100, liviuslivius liviusliv...@poczta.onet.pl [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:

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

If you try something new better use newest snapshot. There are some fixes Regards,Karol Bieniaszewski null

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 17:08 +0100, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 18.12.2018 16:55, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: I'm using the default which I believe is SRP. Make sure by select from

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

18.12.2018 16:55, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: > I'm using the default which I believe is SRP. Make sure by select from MON$ATTACHMENTS. -- WBR, SD.

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

I'm using the default which I believe is SRP. I tried switching to the legacy one earlier today (using FB v3.0.3) but it did not make any difference. Thanks, Bryan On Tue, 2018-12-18 at 16:36 +0100, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Which plugin do you use,

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

Which plugin do you use, srp or legacy? Regards,Karol Bieniaszewski null

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 14:56 +0100, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 18.12.2018 14:44, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: I understand I'm doing it wrong. I don't understand what I need to do

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

18.12.2018 14:44, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: > I understand I'm doing it wrong. I don't understand what I need to do > different. I've read all the documentation (really!). > > If you could give me a working example, that would be awesome. >isql -u sysdba

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 14:28 +0100, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 18.12.2018 14:25, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: Database: localhost:employee, User: TEST Do you see "Role: RDB$ADMIN" here?

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 12:12 +0100, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 18.12.2018 12:04, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: [mypc]$ isql-fb -u test -p test -r rdb$admin localhost:mydatabase Database:

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

18.12.2018 14:25, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: > Database: localhost:employee, User: TEST Do you see "Role: RDB$ADMIN" here? It must be. -- WBR, SD.

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On Tue, 2018-12-18 at 12:52 +0100, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 2018-12-18 12:12, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 18.12.2018 12:04, 'Bryan Cole' bryan.c...@teraview.com > [firebird-support] wrote: >> [mypc]$ isql-fb -u test

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

On 2018-12-18 12:12, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 18.12.2018 12:04, 'Bryan Cole' bryan.c...@teraview.com > [firebird-support] wrote: >> [mypc]$ isql-fb -u test -p test -r rdb$admin localhost:mydatabase >> Database: localhost:mydatabase, User: TEST > >At

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

18.12.2018 12:04, 'Bryan Cole' bryan.c...@teraview.com [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