Managing and Optimizing INFORMIX-OnLine Dynamic Server Databases: Database Security and Integrity

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Application developers, database and system administrators, and technical support personnel

Prerequisites

Previous courses from the Managing and Optimizing INFORMIX-OnLine Dynamic Server Databases suite; the course Relational Principles and the SQL Programming suite; a knowledge of UNIX is necessary (refer to the UNIX curriculum); an understanding of client/server technologies, though not a strict prerequisite, would be useful

Course Aim

To familiarize the student with some of the more advanced database utilities

Learning Objectives

Create and drop views. Import and export data between the database and disk. Alter database tables. Reclaim data space. Modify database elements.

Topics Covered

Data security - Security levels and privileges - Granting privileges - Revoking privileges - Hands-on: Granting and revoking privileges Working with roles and privileges - Role-based authorization - Hands-on: Creating and using roles - Monitoring privileges and roles Data integrity - Integrity and constraints - Semantic and entity integrity - Referential integrity - Hands-on: Setting constraints - Checking, dropping, and monitoring constraints Database object modes - About object modes - Setting object modes Violation detection - Recording violations - The violations table - The diagnostics table