Subject GRANT Privileges
Author Lee Nash

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?


[cid:image070db9.PNG@754bf6a0.47bdf75b]<> []
Lee Nash
T. +44 (0)1749 860666<tel:+44%20(0)1749%20860666>
DD. <tel:+44%20(0)1749%20860666>
M. <tel:+44%20(0)1749%20860666>
[]<> [] <> [] <>

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.

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