You are viewing limited content. For full access, please sign in.

Question

Question

Trigger Security Actions

asked on September 30, 2013

Dears,

 

One of the customer requests is to receive an email notification upon any change in the Laserfiche reposiotry related to:

 

- User's Privileges update.

- User's feature Rights update.

- User's Access Rights update (Entry, Template, Field, Volume).

- User's Securtity Tags update.

- Folder Filter expression.

 

do you have any experience in this?

 

Thanks,

Dory

 

 

0 0

Replies

replied on October 2, 2013 Show version history

I think the way I would approach this is to install SQL triggers on the account_security table to track changes to privileges and feature rights, and a trigger on entry_acl, vol_acl, prop_acl and pset_acl to track changes to entry, volume, field and template ACLs. These triggers would insert a row into a logging table. Then, a separate process can poll this table and send an email. If you have the trigger call into a CLR stored procedure you can do some more complex things without the need for a separate polling process, but the trigger needs to run very quickly so I wouldn't recommend it. It's important that the triggers all start with SET NOCOUNT ON for this to work. Installing a trigger on the toc table would be required to track changes to folder filter expressions but that would be so intrusive that I wouldn't do it.

 

Please note that by installing triggers, you're getting into unsupported territory and this can definitely destabilize the Laserfiche server if it's not done very carefully. A less risky approach would be to frequently import the audit logs into the audit reporting database and scan that for relevant audit events.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.