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, but while Postgres is working
fine Firebird is proving to be sufficiently difficult that I might just
drop it.
Using isql-fb on Debian x86, I've created a database borg_ng with, among
others, a user borg_um to which I've granted admin and rdb$admin rights.
If I use isql-fb running either as root or as firebird with the
rdb$admin role I can create a new user and verify it using gsec:
# isql-fb -user borg_um -password password -role 'rdb$admin'
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect borg_ng;
Database: borg_ng, User: borg_um, Role: RDB$ADMIN
SQL> create user test__4 password 'password';
..
GSEC> di
user name uid gid admin full name
..
TEST__4 0 0
Unfortunately I'm having a lot of difficulty doing this under program
control, with the obvious difference being that FPC/Lazarus is
connecting via a socket.
Has anybody had anything like this working in the past?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
