Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure

Have planned the upgrade of FB, and the works are going on.

Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure

User under manager role should be able to view/modify the procedure and trigger whereas user those are not under manager role should not be able to modify the procedure, they should only be executing the procedure.

Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure

Hi, Firebird-2.5.2.26540_0_Win32 is the firebird i am using.

[firebird-support] Create a table from Query

Hello, Is there any way we could create a table in Firebird using the query? Ex:- create table temptable as select * from tempquerytable t1, tempquery t2 where t1.slno = t2.slno; this creates a table temptable with the structure of both t1 Thanks and Regards

[firebird-support] Foreign Key & Query Performance

Hello there, I am having a doubt that if Foreign Key reduces Query Performance Or not. My Environment is FirebirdCS2.6 :- Item Table :- 10 Records, PK - Itemcode Varchar(5); BillDetail Table :- 10 Million Records (FK Selectivity - 0.0076, PK Selectivity - 0.00076) I am having FK

Re: [firebird-support] Fake error "arithmetic exception, numeric overflow..." on stored procedure or trigger

Check the size of trigger. Sometimes it show like this if the size reaches 64k. On Feb 21, 2018 21:11, "marco andreolli dra...@gmail.com [firebird-support]" wrote: > > > Hi, > Recently I have found the error *arithmetic exception, numeric overflow, > or string

[firebird-support] How to Create a User in Firebird, which has only rights to write 'select' query from database

Hi, User Firebird - 2.5.7 Trying to create a user 'ABC' which should not be having any other rights other than 'SELECT' in the database. If possible block viewing of triggers/procedures/DDLs in Database. CREATE USER ABC PASSWORD 'ABC@123' Thank & Regards

[firebird-support] Get the value of Query Not Available In Table

Hi, I am looking for a solution to get values in query and those not available in table data. CREATE TABLE TEMPTABLE( ID SMALLINT); INSERT INTO TEMPTABLE(ID) VALUES(1); SELECT * FROM TEMPTABLE WHERE ID IN (1,2) in the Above case I want to get the value 2 as output of a

[firebird-support] Re: NBackup Backup Takes Long Time For Level 2.

Thank you Dimitry Sibiryakov for the suggession. I tried a trial with local dummy db of size just 1.5GB in which i tried inserting 10Cr records to one table with only 1 field currenttimestamp and executed. At this same time i started nbackup for this db it also take approximately 20-30 minutes

Re: [firebird-support] Re: Rename a foreign key

have you tried altering rdb$indices ?

[firebird-support] NBackup Backup Takes Long Time For Level 2.

Hi,I have Implemented NBackup in one of my client's Central Database which will be connected by more than 150 Remote Locations, Web Services Etc.Database Size - 40GBOS                   - Windows 2012, 32 GB RamFirebird            - 2.5.6 CSNBackup Frequency -     Level 0 - Sundays,     Level 1