Subject Re: [firebird-support] Execute linux command from stored proc or trigger
Author Alexandre Benson Smith
Hi !

AFAIK it is not possible, and I think it will be a security risk to allow
FB to run server commands.

I think you know that, and have a good reason to want to create a new user
when a user is added to your database table. You do not need a system user
to let your user access the database, I think the database server should
have only 2 users "root" and "firebird".

hth
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br


At 18:13 16/09/2003 +0000, you wrote:

>Hi,
>Can I execute a linux/unix command from a stored procedure or
>trigger? I want create a linux user after insert on my app_user_table.
>I know it's possible to write a UDF, but I'm looking for something
>like "host" command from Oracle.
>
>Thanks.

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.514 / Virus Database: 312 - Release Date: 28/08/2003


[Non-text portions of this message have been removed]