Subject RE: [firebird-support] Firebird 1.5 Users Question
Author Alan McDonald
> Hi,
> I'm developing a security module in Delphi 7 using Firebird 1.5.
> I am looking for a way to list ALL Firebird users, so they can be
> selected and rights assigned to them.
> I have seen the Security.fdb, should I access it directly or are there
> API calls. If I access it directly is there a way of getting the
> correct connection string?
> Thanks
> David

if you want to stick with 1.5 forever, then you can use direct access but
FB2 breaks that regime.
For both 1.5 and 2 you can use the services API so I'd recommend that route
I'm just doing the same thing as we speak. I use IBO and IBOAdmin components
have a component for attaching to the service manager for security calls. I
don't know what component set you use.
I notice that 2 is slightly different to 1.5
In 1.5 you would try to modify a user and if an exception is raised, you add
it. But in 2, there is no exception if you try to modify a non-existent
user, so you need to first check if it exists, then add or modify
appropriately. Effecting changes to ROLEs is still matter of some trivial
SQL commands