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] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure
Hi all, I am trying to GRANT edit/recreate procedures for manager level users and blocking the same from normal users. I was able to do the same in the case of Tables, but for triggers and procedures i am not able to limit the modification rights. please help me on this. thanks and regards.
[firebird-support] Get last time a procedure is accessed.
Hi all, Is there any way that we could log last accessed time of a procedure. I am in a process of cleaning up 8 years old database. DB is having more than 1000 procedures in which only 10-20% will be using now after optimizations and improvisations. If I could get the last accessed time of every procedure it would help me to clear the unused procedures from the DB. It is very difficult to make changes as there are lots of procedures in dependencies. In case there is no logging of procedure's accessed time, I would expect an option to start logging from now onwards, so after a monitoring of 6months to 1 year, I could clear those procedures. It is FB 2.5.7 Thanks.
[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&t2 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 between BillDetail.Itemcode And Item.Itemcode with FK every query is slow. but as i remove the FK and added Index with Itemcode&BillDetail_PK the queries are running lightning fast. But I prefer FK to be in Database with high performance queries. Kindly share you suggestions and Feedbacks on the same.
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 truncation* > > > *string right truncationAt trigger 'X'* > on different trigger or stored procedure. > The strange thing is that are not true, in the trigger or procedure there > isn't any operation that coud produce this exception! > > I "recompile" the trigger or procedure that are affected and the error > disappear!. > It could be a bug in my relase of Firebird? > > > > > > Firebird Ver: WI-V6.3.7.27050 Firebird 2.5 > >
[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 query. Kindly Help. Thanks In Advance.
[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 in the mean while the delta file was increasing, I had also incuded -d ON switch. So do we have to understand that time for nbackup(0/1/2) for an active DB is approximately 30 minutes or is there anything else that has to be taken care.
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 - Daily @ 00:00, Level 2 - Every 15 Minutes. For every Level 2 Backup it takes more than 30 Minutes to complete. Is there anything i need to Check/Improve or if this is the normal time that will take for this kind of Database. Nb:- Surprisingly 30 Minutes is the Same Time Consumed to create a Level 0, 1, 2. In this logically Level 0 has more data than Level 2 Still it consumes same time. Thanks and Regards-- Anto Edin Charley