Courion Tip – Keep your staging tables for the auditors.   Leave a comment

Every night, we truncate our staging tables. Then we import a list of users from target systems to those staging tables, then process them to figure out who has accounts on what systems.  That’s not what I am talking about here.

What if we took that staging table every night and appended it to another table, and added a date/time stamp column??

That way, we would have a list of what users had accounts on what systems over the entire year. The auditors are excited about this, and I will be implementing it soon.

Advertisements

Posted September 28, 2009 by mmdmurphy in Courion Tip, tips

Tagged with

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: