NORTH AMERICA EMEA ASIA
All programs BankAudit 2013 InfoSec World Conference & Expo 2013 SuperStrategies Conference & Expo 2013 The Conference on Big Data Security
All programs The Audit Directors & Managers Symposium The MIS Audit Leadership Institute The MIS CAE Master's Program
ABOUT MIS INTERNAL AUDIT IT AUDIT INFO SECURITY IN-HOUSE TRAINING  
 
     Conferences            >      Seminars            >      Symposia            >      Webinars      Online Self Study      Training Weeks      In-House Training      Certificate Programs>      Exhibiting Info      Ways to Save      Request Info      Event Downloads      White Papers      Call for Instructors      Contact MIS      Site Map
Internal Audit IT Audit Info Security
Internal Audit IT Audit Info Security
Auditing Database Management Systems - ASE360 
Ensuring Proper Controls are in Place in SQL Server, Database 2, MySQL and SYBASE Adaptive Server
Learning Level: Advanced
CPEs: 24 Fee: $2,350.00
Focus and Features Who Should Attend Agenda Register
Agenda

What You Will Learn
1. Database Environments
- terminology
- components
- platforms
- architectures
- basic risks and exposures

2. Objects
- common data objects
- common program objects
- common control objects
- product specific objects (Sybase)

3. Account Management
- high-risk users (MySQL)
- standard users
- authentication methods (MS SQL Server)
- grouping structures (DB2)

4. Environmental Access Control
- high-risk privileges
- special GRANTS and REVOKES (MySQL)
- encryption (Sybase)
- network controls
- server-to-server communications (MS SQL Server)

5. Data Access Control
- object privileges
- standard GRANTS and REVOKES
- views
- stored procedures (DB2)
- detective mechanisms
- accounting audit trails

6. Integrity Controls - Part I
- constraints
- referential integrity (DB2)
- deadlock detection/resolution (MySQL)
- optimistic concurrency
- universal change/missing update controls

7. Integrity Controls - Part II
- program change control (MS SQL Server)
- system parameter change control 
- patch management

8. Additional Controls
- backup/recovery
- replication (Sybase)
- licensing
- facility management charges

9. Impact on the Organization
- security profiles
- roles and responsibilities
- organization placement
- auditing the DBA function
- areas for standardization

10. Summary
- audit types
- audit program
- objectives review
- evaluations

 
REGISTRATION QUESTIONS?
For questions about your registration, government and team discounts, or multiple registrations, please call Linda Ronconi at (508) 879-7999, ext. 501 or e-mail mis@misti.com.

IN-HOUSE SEMINARS
This seminar is available in-house. For more information about bringing this or other MIS seminars to your organization, please call Mimi Hatch at (410) 692-2465 or e-mail mhatch@misti.com.

 


Dates/Locations
June 19 - 21, 2013
Boston