Thanks Mark,
Yes and I now I see it and don't know how I missed it before...
Regards
R~~
On Tue, 31 Jul 2018, 20:53 Mark Rotteveel m...@lawinegevaar.nl
[firebird-support], wrote:
>
>
> On 31-7-2018 10:44, trueriver river14ap...@gmail.com [firebird-support]
> wrote:
> > So my question is
> >
>
Hi,
I’m struggling to grant any privileges on a .fdb file database.
I have created a separate user as the SYSDBA reported “Your login SYSDBA is
same as one of the SQL role name. Ask your database administrator to set up a
valid Firebird Login”.
When I use ISQL to run a select statement on the
Hi Mark,
Thank you that’s exactly what I did!! I created a new user named the exact same
as the user that created the role and o got access to the data..
Thank you for taking the time to answer!
Sent from my iPhone
On 31 Jul 2018, at 20:53, Mark Rotteveel
Lee,
> I’m struggling to grant any privileges on a .fdb file database.
> I have created a separate user as the SYSDBA reported “Your login
> SYSDBA is same as one of the SQL role name. Ask your database
> administrator to set up a valid Firebird Login”.
The SYSDBA user exists already. The
On 31-7-2018 16:18, Lee Nash leen...@barbers.co.uk [firebird-support] wrote:
> I’m struggling to grant any privileges on a .fdb file database.
>
> I have created a separate user as the SYSDBA reported “Your login SYSDBA is
> same as one of the SQL role name. Ask your database administrator to
On 31-7-2018 10:44, trueriver river14ap...@gmail.com [firebird-support]
wrote:
> So my question is
>
> a: is there a CLI client I have overlooked in the docs?
Yes there is: isql (although some distributions rename it, eg isql-fb on
Ubuntu). See also
I am used to creating tables and users and even databases by typing SQL
into a command line client.
Forgive me if I am missing some clue in the documention but there I have
not found anything about how to do that for firebird 3.0
FlameRobin composes create table SQL for you and you fill in the