September 16, 2008 5:58 PM
Posted by: Arian Eigen Heald
Admins and Auditors,
Compliance,
Database,
Database security,
free tools,
IT audit,
Microsoft Windows,
PCI DSS,
Security,
SOX,
SQL Server,
Steps to an Easy Audit,
Tools for Auditing and SecurityThere's a lot of really nice application tools to audit SQL databases out there. They have lots of bells and whistles and write out a really nice report with professional formatting. If you've got one of those, LUCKY YOU. But most of us Admins and Auditors have to scrounge for what we can find...
September 12, 2008 2:14 PM
Posted by: Arian Eigen Heald
Admins and Auditors,
Compliance,
Database,
Database security,
IT audit,
Security,
SQL Server,
Tools for Auditing and SecurityThe first question to answer is: "Is the SQL system patched?" You or a DBA can confirm this inside Enterprise Manager (the software client that runs on SQL or from a remote installation of it) by right-clicking the primary database icon and selecting Properties. You can also run a query inside...
August 21, 2008 3:48 PM
Posted by: Arian Eigen Heald
Admins and Auditors,
Compliance,
Data Breaches,
Database,
Database security,
DataManagement,
Identity theft,
IT audit,
Oracle,
PCI DSS,
SAP,
SAS 70,
Security,
SOX,
SQL ServerDatabases are enormous, powerful repositories of data. They can hold payroll, HR personnel data (think social security numbers) stock prices, Accounts Receivable, Client Relationship Management, and customer information. Banks can't live without them. Most medium and many small sized businesses...
August 19, 2008 1:20 PM
Posted by: Arian Eigen Heald
Admins and Auditors,
Compliance,
Data Breaches,
Database,
Database security,
DataManagement,
Identity theft,
IT audit,
Oracle,
PCI DSS,
SAP,
SAS 70,
Security,
SOX,
SQL ServerSo many financial auditors, CEOs, CFOs and others rely on electronic data to understand the complexities of General Ledger, Accounts Payable, etc. In this era of SAP, ADP, electronic time clocks, etc., the one common denominator is the database underlying each application.
Applications...
May 13, 2008 4:38 PM
Posted by: Arian Eigen Heald
Compliance,
Database,
Database security,
IT audit,
PCI DSS,
Security,
SQL Server,
Steps to an Easy AuditRemember that commercial (I'm dating myself, I know) where the little old lady lifts the top of the burger bun and says, "Where's the beef?" All things considered, we have to ask the same sorts of questions about data.
Usually we're...
