Keeping Track of User access

[dh4234]

I was given the task of creating some sort of user access matrix. My company wants a db or list of some sort that tracks what systems users have access to. Has anyone else had a similar requirement? If so how did you set it up? They tell me this needs to auditable to meet some sort of SOX requirement. I was thinking I could set this up as a CI, but I'm not sure if that is the best way to do it. Ideas would be greatly appreciated.

[brad_hicks]

Another trick you should be aware of... There is a field that isn't on the field map form by default called "Referenced value field name". If you are mapping a field from your source table to the target table and the target table field is a reference field then it is looking for the sys_id as the value. By adding this field to your field map form you can choose a different field to match the value to. In your example you have a field on your source table called userid that you would map to the assigned_to reference field. Then you would populate the "referenced value field name" with user_name. It will do the match for you and then automatically populate the field properly without any scripting involved.

[dh4234]

That works great, and it runs faster than a transform script.

Thanks