Re: [firebird-support] Users belonging to the role ADMIN

2013-01-13 Thread Thomas Steinmaurer
Hello Sergio, > I'm using FB v2.5.1.26351 and Delphi v2007. In my application I need to > retreive a list of all users, and using IBSecurityService component > ("Interbase Admin" page) that it's done; but I want to know which users > belong to the Admin role (users created with "CREATE USER ...

Re: [firebird-support] Do I need to recompile a stored procedure?

2013-01-13 Thread Thomas Steinmaurer
> Hi. Firebird 2.5.1 here. > > Lets assume that I have two stored procedures, PROC_A, PROC_B. > PROC_A is using internally a PROC_B. After some time I've changed a body of > PROC_B but not the input or output. I've recompiled PROC_B. > Do I need to also recompile a PROC_A? > > Many times I've obse

[firebird-support] Auto Back up

2013-01-13 Thread Andy Gable
Hi all, What method you all recommend I use to create a back up of the database (I would like the back up to happen every night) I would like this to happen thanks to the Windows Task Scheduler service Andy [Non-text portions of this message have been removed]

Re: [firebird-support] sweep start & running

2013-01-13 Thread Thomas Steinmaurer
> I'm trying to track down an intermittent performance issue, and I find I > don't have sufficient grasp of sweep behavior. > > firebird 2.1.5 classic on centos > > I understand that a sweep is started (new thread is created) when OST-OIT > > 2 (by default). What I can't find documented is when

Re: [firebird-support] Auto Back up

2013-01-13 Thread Thomas Steinmaurer
> What method you all recommend I use to create a back up of the database (I > would like the back up to happen every night) > > > > I would like this to happen thanks to the Windows Task Scheduler service With a plain old gbak call? Make sure, that: * You are using a TCP/IP connect string to th

[firebird-support] Re: installation on Linux as non-root

2013-01-13 Thread philippe makowski
sargei_tartar [2013-01-12 16:17] : > > I'm trying to install firebird under Linux on a machine where I don't have > root access, but install.sh fails with the error "You need to be 'root' user > to do this change." How can this be done? > short answer, you can't Firebird full install need to

[firebird-support] Re: installation on Linux as non-root

2013-01-13 Thread sargei_tartar
Perhaps I don't need a full install -- I intend to replace SQLite, so am only interested in the embedded mode (single local file, single process). --- In firebird-support@yahoogroups.com, philippe makowski wrote: > > sargei_tartar [2013-01-12 16:17] : > > > > I'm trying to install firebird und

[firebird-support] Re: Do I need to recompile a stored procedure?

2013-01-13 Thread un_spoken
> Vote for it: > http://tracker.firebirdsql.org/browse/CORE-2472 > > Regards, > Thomas Thanks! Voted.

Re: [firebird-support] Re: installation on Linux as non-root

2013-01-13 Thread Fulvio Senore
This should help you: http://www.firebirdfaq.org/faq51/ Il 13/01/2013 16.55, sargei_tartar ha scritto: > Perhaps I don't need a full install -- I intend to replace SQLite, so am only > interested in the embedded mode (single local file, single process). > > --- In firebird-support@yahoogroups.co