> 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
http://www.upscene.com
http://blog.upscene.com/thomas/

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