[fpc-pascal] Re: Connecting to Firebird using FPC/Lazarus over a LAN with user creation privilege

[Reinier Olislagers]

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 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 been naive in assuming that isql's CREATE USER was submitted
> as such, rather than being translated to API call(s) inside the program.

Don't know exactly what you mean by differing subsets; AFAIU they're all
regular SQL as far as Firebird is concerned. They should work in e.g.
Flamerobin just as they do in isql.

Management tasks that used to only be exposed by the services API are
now also being offered through SQL (user management, grant management...)
You do need to pay attention you're not using some prehistory FB version
- don't know when exactly CREATE USER was introduced, probably in 2.0 or
2.1 or something...