Strored procedure error 668: System command cannot be executed

[blessingk]

Hi

- Using IDS vrer 7.31.UC6AX7

- System call from Stored procedure is giving me this error

668: System command cannot be executed.1: Not owner

- Calling the script in SP like so
SYSTEM "/appl/local/bin/send_notification C" || var_space || var_awb || var_space || var_contact ;
The script sends an e-mail to var_contact.

- Script is owned by root , group informix.

- Running SP as user root.


Please help ...

rgs
bk

 

[olded]

bk:

Within informix user root is nobody special unless you make them special. If root is executing SP you have to give them permission:

GRANT EXECUTE ON <sp name> TO root

You are doing well to use a full path to the executable - especially if root is the user.

Regards,

Ed

 

[blessingk]

Tried what you suggested , but no luck still

Any more thoughts in this will be helpfull.

rgs
bk

 

[vpshriyan]

Hi,

You may recreate the SP with &quot;DBA&quot; keyword and check it.

Example:

CREATE DBA PROCEDURE myproc ( ... )

Regards,
Shriyan