Re: [firebird-support] CLI to firebird

2018-07-31 Thread 'River~~' river14ap...@gmail.com [firebird-support] 
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
> >
> > 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
>
> https://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/isql.html
>
> Mark
> --
> Mark Rotteveel
> 
>

[firebird-support] GRANT Privileges

2018-07-31 Thread Lee Nash leen...@barbers.co.uk [firebird-support] 
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 database in question I get the 
response:

“Statement failed, SQLSTATE = 28000
No permission for read/select access to TABLE ZIEKTE”

Then I try to GRANT SELECT on TABLE ZIEKTE to USER DW_EXTRACT” however I get 
the response:

“Statement failed, SQLSTATE = 28000
Unsuccessful metadata update
-no S privilege with grant option on table/view ZIEKTE”

I’ve tried numerous tables but I get the same response.
I have tested the user on the Example database “EMPLOYEE” and have no problems 
accessing any table on that.
Can you possibly help me or point me in the right direction?

Thanks
Lee


[cid:image070db9.PNG@754bf6a0.47bdf75b]
 
[https://cdn.shopify.com/s/files/1/1217/7686/files/linePad2.png?10176742118938381070]
Lee Nash
MARYLAND FARM, DITCHEAT,
SOMERSET, BA4 6PR, ENGLAND
T. +44 (0)1749  860666
DD. 
M. 
leen...@barbers.co.uk
www.barbers.co.uk
[https://cdn.shopify.com/s/files/1/1217/7686/files/003Face_294c9508-4fae-4a82-a5a0-185bf7572ee8.png?3457714132398832093]
   
[https://cdn.shopify.com/s/files/1/1217/7686/files/002Insta_cda37848-99d2-457a-ac28-3beb0d6f38f3.png?3457714132398832093]
 
[https://cdn.shopify.com/s/files/1/1217/7686/files/001Twit_b35541d8-ec84-4409-aa8c-9007c2c51c54.png?3457714132398832093]
 


Barbers is a trading name of A.J & R.G Barber Limited and its wholly owned 
subsidiaries. A.J & R.G Barber Limited is a company registered in England and 
Wales (Registered No. 0551460). Registered Office: Maryland Farm, Smiths Lane, 
Ditcheat, Shepton Mallet, Somerset, UK, BA4 6PR. This e-mail, its attachments 
and any other items transmitted with it are confidential and intended only for 
the addressee named above. If you are not the intended recipient you must not 
use, copy or distribute to any other person the contents of this message but 
should immediately reply to the sender and then delete the message from your 
computer system. VIRUSES - Viruscan has been used to check this e-mail for 
viruses. However, Barbers cannot guarantee that this e-mail and attachments are 
free of viruses and you must ensure that you carry out your own virus checks. 
Barbers accepts no liability for any loss or damage suffered by any person 
arising from use of this e-mail. Any personal opinions expressed in this e-mail 
are views of the individual and do not necessarily reflect the views of Barbers.


This message has been scanned for malware by Websense. www.websense.com


[Non-text portions of this message have been removed]

Re: [firebird-support] CLI to firebird

2018-07-31 Thread Lee Nash leen...@barbers.co.uk [firebird-support] 
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 
m...@lawinegevaar.nl [firebird-support] 
mailto:firebird-support@yahoogroups.com>> 
wrote:



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
https://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/isql.html

Mark
--
Mark Rotteveel





Click here to report 
this email as spam.

[cid:image3c63d2.PNG@78d731f4.42a606dc]
 
[https://cdn.shopify.com/s/files/1/1217/7686/files/linePad2.png?10176742118938381070]
Lee Nash
MARYLAND FARM, DITCHEAT,
SOMERSET, BA4 6PR, ENGLAND
T. +44 (0)1749  860666
DD. 
M. 
leen...@barbers.co.uk
www.barbers.co.uk
[https://cdn.shopify.com/s/files/1/1217/7686/files/003Face_294c9508-4fae-4a82-a5a0-185bf7572ee8.png?3457714132398832093]
   
[https://cdn.shopify.com/s/files/1/1217/7686/files/002Insta_cda37848-99d2-457a-ac28-3beb0d6f38f3.png?3457714132398832093]
 
[https://cdn.shopify.com/s/files/1/1217/7686/files/001Twit_b35541d8-ec84-4409-aa8c-9007c2c51c54.png?3457714132398832093]
 


Barbers is a trading name of A.J & R.G Barber Limited and its wholly owned 
subsidiaries. A.J & R.G Barber Limited is a company registered in England and 
Wales (Registered No. 0551460). Registered Office: Maryland Farm, Smiths Lane, 
Ditcheat, Shepton Mallet, Somerset, UK, BA4 6PR. This e-mail, its attachments 
and any other items transmitted with it are confidential and intended only for 
the addressee named above. If you are not the intended recipient you must not 
use, copy or distribute to any other person the contents of this message but 
should immediately reply to the sender and then delete the message from your 
computer system. VIRUSES - Viruscan has been used to check this e-mail for 
viruses. However, Barbers cannot guarantee that this e-mail and attachments are 
free of viruses and you must ensure that you carry out your own virus checks. 
Barbers accepts no liability for any loss or damage suffered by any person 
arising from use of this e-mail. Any personal opinions expressed in this e-mail 
are views of the individual and do not necessarily reflect the views of Barbers.


This message has been scanned for malware by Websense. www.websense.com


[Non-text portions of this message have been removed]

Re: [firebird-support] GRANT Privileges

2018-07-31 Thread Helen Borrie hele...@iinet.net.au [firebird-support] 
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 password is 'masterkey' but you
should change this immediately.

> When I use ISQL to run a select statement on the database in question I get 
> the response:

> “Statement failed, SQLSTATE = 28000
> No permission for read/select access to TABLE ZIEKTE”

> Then I try to GRANT SELECT on TABLE ZIEKTE to USER DW_EXTRACT” however I get 
> the response:

> “Statement failed, SQLSTATE = 28000
> Unsuccessful metadata update
> -no S privilege with grant option on table/view ZIEKTE”

You need to be logged in as SYSDBA or the database owner.  An ordinary
user can't grant permissions to self nor to any other user.

> I’ve tried numerous tables but I get the same response.
> I have tested the user on the Example database “EMPLOYEE” and have
> no problems accessing any table on that.

AFAIR, all the tables in the employee database have rights granted to
PUBLIC.  This isn't something you should do with a real-life database,
though.

> Can you possibly help me or point me in the right direction?

If you don't know the db owner's credentials then log in as SYSDBA.

If you post again, would you please exclude all the company stuff in
the sig of your posting.

Helen


---
This email has been checked for viruses by AVG.
https://www.avg.com

Re: [firebird-support] GRANT Privileges

2018-07-31 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
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 set up a 
> valid Firebird Login”.
> 
> When I use ISQL to run a select statement on the database in question I get 
> the response:
> 
> “Statement failed, SQLSTATE = 28000
> No permission for read/select access to TABLE ZIEKTE”
> 
> Then I try to GRANT SELECT on TABLE ZIEKTE to USER DW_EXTRACT” however I get 
> the response:
> 
> “Statement failed, SQLSTATE = 28000
> Unsuccessful metadata update
> -no S privilege with grant option on table/view ZIEKTE”
> 
> I’ve tried numerous tables but I get the same response.
> I have tested the user on the Example database “EMPLOYEE” and have no 
> problems accessing any table on that.
> Can you possibly help me or point me in the right direction?

The original author of this database created a role SYSDBA to prevent 
the user SYSDBA from working.

You can't simply grant yourself rights. If that were possible, security 
would be a joke (especially if - as the name ZIEKTE (which is Dutch for 
disease, illness or sick leave) suggests - this potentially concerns 
confidential personal data).

Now assuming you actually have the moral and legal right to access this 
data (eg under the GDPR), you should find out which user does have the 
appropriate rights and login with that user. You may need to create the 
user first (user accounts in Firebird are - usually - centrally 
administered, while rights are (linked to user names) per database).

Alternatively, you could try to drop the sysdba role or - assuming this 
is Firebird 2.5 or earlier - you could try to delete the role SYSDBA 
directly from the RDB$ROLES table. You may need to create a user account 
with the same name that originally created that role.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] CLI to firebird

2018-07-31 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
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 
https://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/isql.html

Mark
-- 
Mark Rotteveel

[firebird-support] CLI to firebird

2018-07-31 Thread trueriver river14ap...@gmail.com [firebird-support] 
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 gaps, but
I want to just type it in at a prompt, as in Oracle, Mysql, Mariadb and
loads of other DBMSs I have used over the years

I can see that FlameRobin is a gentler learning curve for newcomers but
when you know SQL (and can adapt to the inconsistent way it's implemented)
it feels so clunky to keep having to swap from mouse to keyboard

So my question is

a: is there a CLI client I have overlooked in the docs?

b: is there a third party CLI client for use from a bash terminal on Linux?

Regards
R~~

> 
>