On 9-3-2013 17:31, Mark Morgan Lloyd wrote:
> Tony Whyman wrote:
>> Mark,
>>
>> I did something like this a few years ago and the Services API is your
>> friend - but it is not standard SQL...
>
> [Nod] I suspect that the key is the way that Firebird documents various
> activities as differing sub
On 9-3-2013 19:56, Mark Morgan Lloyd wrote:
> Reinier Olislagers wrote:
>> On 9-3-2013 17:31, Mark Morgan Lloyd wrote:
> It identifies itself as 2.5, and by that I explicitly mean that I'm
> querying it rather than trusting any claims by the Debian package
> maintainer, and according to the documen
On 9-3-2013 14:08, Mark Morgan Lloyd wrote:
> I don't know whether anybody can help me with this one, but I'm working
> on something where I need a program to be able to create login-capable
> database users on-the-fly. I was hoping to be able to use either
> PostgreSQL or Firebird as the backend
On 10-3-2013 11:21, Mark Morgan Lloyd wrote:
> reinierolislagers-re5jqeeqqe8avxtiumw...@public.gmane.org wrote:
>> On 9-3-2013 14:08, Mark Morgan Lloyd wrote:
>>> I don't know whether anybody can help me with this one, but I'm working
>>> on something where I need a program to be able to create log
On 10-3-2013 12:03, Mark Morgan Lloyd wrote:
> Reinier Olislagers wrote:
>> On 9-3-2013 19:56, Mark Morgan Lloyd wrote:
>>> Reinier Olislagers wrote:
On 9-3-2013 17:31, Mark Morgan Lloyd wrote:
>> Well...
>> Background: Create user via SQL:
>> http://www.firebirdsql.org/refdocs/langrefupd25-se
On 9-3-2013 14:08, Mark Morgan Lloyd wrote:
> I don't know whether anybody can help me with this one, but I'm working
> on something where I need a program to be able to create login-capable
> database users on-the-fly. I was hoping to be able to use either
> PostgreSQL or Firebird as the backend,
On 11-3-2013 9:24, Mark Morgan Lloyd wrote:
> Reinier Olislagers wrote:
>>> Subject to a maximum user name length of 31 characters on Firebird. The
>>> manual suggests that PostgreSQL has a limit of 64.
> True, but I thought that a detail relating to something that people were
> likely to do compa
Reinier Olislagers wrote:
On 9-3-2013 17:31, Mark Morgan Lloyd wrote:
[Nod] I suspect that the key is the way that Firebird documents various
activities as differing subsets of SQL, i.e. defining a table is one
subset, accessing it is another, managing users a third and so on. I
could have bee
reinierolislag...@gmail.com wrote:
On 9-3-2013 14:08, Mark Morgan Lloyd wrote:
I don't know whether anybody can help me with this one, but I'm working
on something where I need a program to be able to create login-capable
database users on-the-fly. I was hoping to be able to use either
PostgreSQ
On 10 Mar 2013, at 11:21, Mark Morgan Lloyd wrote:
> reinierolislag...@gmail.com wrote:
> Have you tried the Firebird admin module that Ludo Brands wrote? It
>> connects using the FB service interface and allows user creation.
>> Firebird also offers CREATE USER SQL AFAIR (since FB 2.5, perhaps e
Reinier Olislagers wrote:
On 9-3-2013 19:56, Mark Morgan Lloyd wrote:
Reinier Olislagers wrote:
On 9-3-2013 17:31, Mark Morgan Lloyd wrote:
It identifies itself as 2.5, and by that I explicitly mean that I'm
querying it rather than trusting any claims by the Debian package
maintainer, and acco
Reinier Olislagers wrote:
I've not tried that yet, but it's on
the list. I've just spent a while checking that some related SQL works
with PostgreSQL (i.e. getting quoting correct etc.) since it's easier to
debug.
As mentioned in other posts: you should be able to create users and
assign datab
Reinier Olislagers wrote:
But I can't do that last step from a TIBConnection. There's obviously a
possibility that I'm Doing It Wrong: what's the Firebird equivalent of
PQExec(), I'm using isc_dsql_execute_immediate()?
Strange.
Setting the user to borg_um, the role to RDB$ADMIN, correct passwor
Reinier Olislagers wrote:
I've written a demo application that:
uses regular TIBConnection and SQL commands to
1. create a new db on a server
2. create a user with GRANT ADMIN ROLE and full control over the new db
Source:
https://bitbucket.org/reiniero/fpc_laz_patch_playground/downloads/firebir
Reinier Olislagers wrote:
I've written a demo application that:
uses regular TIBConnection and SQL commands to
1. create a new db on a server
2. create a user with GRANT ADMIN ROLE and full control over the new db
Source:
https://bitbucket.org/reiniero/fpc_laz_patch_playground/downloads/firebird
On 10-3-2013 21:56, Mark Morgan Lloyd wrote:
> Reinier Olislagers wrote:
>> I've written a demo application that:
>> uses regular TIBConnection and SQL commands to
>> 1. create a new db on a server
>> 2. create a user with GRANT ADMIN ROLE and full control over the new db
>
> Subject to a maximum
Reinier Olislagers wrote:
Subject to a maximum user name length of 31 characters on Firebird. The
manual suggests that PostgreSQL has a limit of 64.
If you're going to list all differences between PG and FB as you hit
them, you might put them on a wiki page for easy retrieval by others.
The t
17 matches
Mail list logo