Automatically adding an IP to the ip_access table based on activity on the syslog_transaction.

[Txilos]

Hi,

I'm trying to create a business rule or flow on the  Transaction Log (syslog_transaction) table,

that will basically check the record transaction and then uses the IP Address value  to create a record on the IP Address Access Controls(ip_access) if certain conditions are met.

This seems to work fine, until the created_by (on syslog_transaction) is a guest user.

It seems it's while the business rule is in fact triggered, it's trying to create the record on the ip_access table using the guest user and of course failing because the guest user has no rights on the table.

My question is, how can the business rule script that creates the record on the ip_access table be executed by the system user, regardless if the record that triggered the business rule was created by a guest account.

regards,

Theo.

[Mark Manders]

Are you sure you want to grant the 'guest user' access rights through IP whitelisting? 

On the other hand: are you sure this is the cause? Are all users for which other IP's are added able to create those records? Because that doesn't really sound secure, but I can't look inside your instance of course.