By: Charles Rice, Director of Software Development

Who updated my data?

Have you ever wanted to see who updated a piece of information?  Even software with a full audit list of changes made by the system, how can you be certain nothing was done “outside” the system?  Microsoft SQL Server is a backend database that can keep a transactional log of every change that has happened to your data.  Using tools like ApexSQL Log  gives you the ability to read the log file and find out who changed the data, even if it happened outside of your software system.

The key is having a user ID in your software being a user id in SQL Server and having a software system that does this for you automatically.  The system can generate a password to connect to SQL Server that is a hash of their password to log into the software.  This provides easy traceability in the SQL transaction log back to the user inside your software system without giving the user the ability to log into SQL Server outside of the software system.   Using both the software transactional data inside the system and using SQL Server transaction logs, you will be able to track who updated information even if it was done outside the system easily.

by: Rebecca Kempenich 

Are you interested in improving operational efficiencies while reducing cost and increasing customer satisfaction? We are and we are talking about it. Welcome to the ProcessPro Software Blog. We launched this blog to provide the process manufacturing community a resource to turn to find industry-related information, especially in the following areas: 

• Industry Best Practices in:
  ·     inventory management
  ·     customer fulfillment
  ·     distribution
  ·     materials management
  ·     transportation
  ·     warehousing
  ·     supply chain management
  ·     purchasing
  ·     planning & scheduling

• ERP Software Selection
• Software Technology & Architecture
• Implementing ERP
• FDA Compliance
• ProcessPro ERP Software FAQ

Weekly postings from our blog authors and industry experts will provide many ideas, opinions and discussion on how to improve your manufacturing business across the entire enterprise. Join the discussion. Tell us about the topics you are interested in. Post a comment below.