Re: ODP: [firebird-support] Converting dates and the ISO-8601 format

2018-11-11 Thread i...@synapsesoftware.co.uk [firebird-support]
Because I need a true client /server arrangement - from what I can see the 
embedded solution is really only for peer to peer connections on  a local 
system. You cannot connect remotely or share data on a central server (there 
are also security restrictions from what I can see,)

ODP: [firebird-support] Converting dates and the ISO-8601 format

2018-11-11 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
>>I trying to find a web host that will run a firebird server is very hard

Why? Do you hear about embeded Firebird? 
I use FB embeded on the hosting environment without the problem

Regards,
Karol Bieniaszewski


Re: [firebird-support] Converting dates and the ISO-8601 format

2018-11-11 Thread i...@synapsesoftware.co.uk [firebird-support]
ok thanks Lester, I will head over there and see whats happening. I like 
firebird a lot and have used it for years so Im kind of invested in it. In 
hindsight, perhaps - perhaps I should have gone with MySql (seems like everyone 
else has :))
 

 You are right about it not getting much love, trying to find a web host that 
will run a firebird server is very hard and if you do - its usually a lot more 
than the same MySql service. Not sure why that should be, but hey ho - guess 
its what the market will bear.
 

 Will head over to the list you mentioned

 

 Cheers,,
 

 Dave

 



Re: [firebird-support] Does GRANT... TO PUBLIC has no more effect anymore?

2018-11-11 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 10-11-2018 13:33, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
>> I can confirm it works correctly in 2.5.x (can't say anything about 3.x
>> though). We're using the same approach (the users of our system are
>> actually created as FB users, so granting access to PUBLIC is more
>> convenient than having to execute dozens of grants after adding each new
>> user; I know it has some downsides, but that's not the point here).
> 
> Firebird 4 will introduce default roles (though technically PUBLIC is a
> default role as well) which will allow more control by granting users a
> default role. That way they will get the rights of those default roles
> without having to explicitly specify a role on connect.

And I just found out that with Firebird 3's authentication mapping, you 
can define a mapping that will automatically grant and enable a role.

Mark
-- 
Mark Rotteveel