Subject Re: [firebird-support] CREATE USER on TRIGGER / SP
Author Thomas Steinmaurer
> Anyone could explain to me why I can't place this
> CREATE USER operator PASSWORD 'masterkey';
> on Trigger / SP ?
> Then how I could make it.

In general, DDL statements are prohibited in PSQL. But you can wrap any
statement into an EXECUTE STATEMENT <your_sql_string>. Haven't tried if
this works for user management as well.

With regards,

Thomas Steinmaurer
Upscene Productions

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!