Re: [firebird-support] confusion trigger
It is not possible to grant permission to triggers from what I know (FlameRobin) Possibly if the trigger break into two parts, one with insert and update, other with delete solve the problem. In the end I granted the right to delete on table Tab2. From: Björn Reimer bjoern.rei...@fau.de Are you aware of the possibility to grant permissions to triggers? That should solve your problem. Why User1 is restricted for any insert or update operation ? User1 privileges: Tab1 - select,insert,update,delete Tab2 - select,insert update Trigger Tab1_BA BEFORE Insert or Update or Delete Begin if (inserting) then begin ... end if (updateing) then begin ... end if (deleting) then begin delete from Tab2 where ... end End I know that this problem is solved if we add to Tab2 delete but why is not correct formulation above Björn [Non-text portions of this message have been removed]
Re: [firebird-support] confusion trigger
At 06:34 p.m. 21/04/2013, Virna Constantin wrote: It is not possible to grant permission to triggers from what I know (FlameRobin) grant delete on Tab2 TO TRIGGER Tab1_BA You can also grant privileges to PROCEDURE and VIEW. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __
Re: [firebird-support] confusion trigger
Thanks for the reply but especially for new perspectives to grant rights. The options are also in FlameRobin but there was no one to see it :( From: Helen Borrie hele...@iinet.net.au At 06:34 p.m. 21/04/2013, Virna Constantin wrote: It is not possible to grant permission to triggers from what I know (FlameRobin) grant delete on Tab2 TO TRIGGER Tab1_BA You can also grant privileges to PROCEDURE and VIEW. [Non-text portions of this message have been removed]
[firebird-support] building table relationships on a firebird database
I have a Firebird database with 2 tables namely masterlist and daily collection. I used Zeos 7.0.3 to access my Firebird database. My masterlist contains the following columns: #9556;#9552;#9552;#9552;#9552;#9552;#9552;#9574;#9552;#9552;#9552;#9552;#9552;#9552;#9574;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9574;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9559; #9553; name #9553; date #9553; balance #9553; status #9553; #9562;#9552;#9552;#9552;#9552;#9552;#9552;#9577;#9552;#9552;#9552;#9552;#9552;#9552;#9577;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9577;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9565; My daily collection contains the following columns: #9556;#9552;#9552;#9552;#9552;#9552;#9552;#9574;#9552;#9552;#9552;#9552;#9552;#9552;#9574;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9574;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9559; #9553; date #9553; name #9553; payment #9553; balance #9553; #9562;#9552;#9552;#9552;#9552;#9552;#9552;#9577;#9552;#9552;#9552;#9552;#9552;#9552;#9577;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9577;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9552;#9565; I would like to build a relation in which the balance from masterlist will be copied to the balance column of the daily collection, and when I update the column in the daily collection it will also update the content of the masterlist.
[firebird-support] how to build a relationship between 2 tables in firebird?
I have a Firebird database with 2 tables namely masterlist and daily collection. I used Zeos 7.0.3 to access my Firebird database. My masterlist contains the following columns: name date balance status My daily collection contains the following columns: date name payment balance I would like to build a relation in which the balance from masterlist will be copied to the balance column of the daily collection, and when I update the column in the daily collection it will also update the content of the masterlist.