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

2018-12-19 Thread 'Bryan Cole' bryan.c...@teraview.com [firebird-support]
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] Preparing for upgrade from 1.56 to 3 or 4

2018-12-19 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 19.12.2018 at 17:33, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Although I haven't read it myself, consider buying "Migration Guide to > Firebird 3" by Carlos Cantu, see > https://www.firebirdnews.org/migration-guide-to-firebird-3/ Just taking the occasion of this topic

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

2018-12-19 Thread 'Bryan Cole' bryan.c...@teraview.com [firebird-support]
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] Preparing for upgrade from 1.56 to 3 or 4

2018-12-19 Thread 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]
<> http://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf Regards Paul

[firebird-support] Preparing for upgrade from 1.56 to 3 or 4

2018-12-19 Thread my...@techsol.org [firebird-support]
I have a few older FB databases that will need upgrading to later versions. They are pretty large, and most have between 500-1,000 stored procedures. Some contain many tables with millions of rows of data. This is not likely to be a small undertaking. Although I realize there are services

Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4

2018-12-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 19-12-2018 17:01, my...@techsol.org [firebird-support] wrote: > I have a few older FB databases that will need upgrading to later > versions.  They are pretty large, and most have between 500-1,000 stored > procedures.  Some contain many tables with millions of rows of data. > This is not

[firebird-support] Firebird 2.5 ppa repository for Ubuntu 18.04

2018-12-19 Thread my...@techsol.org [firebird-support]
There is reference to installing Firebird 2.5.x on Ubuntu on the website at https://firebirdsql.org/manual/ubusetup.html https://firebirdsql.org/manual/ubusetup.html but this information is very old. The repository that is referenced does not seem to work with Ubuntu 18.04. When I attempt

Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4

2018-12-19 Thread my...@techsol.org [firebird-support]
Thank you so much for this information. Priceless!