Subject | Re: [firebird-support] Execute linux command from stored proc or trigger |
---|---|
Author | Alexandre Benson Smith |
Post date | 2003-09-16T19:52:25Z |
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:
---
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]
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]