Sybase 12.4.2 manual Security overview, Overview of Adaptive Server IQ System Administration

CHAPTER 1 Overview of Adaptive Server IQ System Administration

Table 1-1: Administrative tasks
If you want to know how to...	Look in...
Install and configure Adaptive Server	Adaptive Server IQ Installation and
IQ for your platform	Configuration Guide
Start and stop the database server, and	Chapter 2, “Running Adaptive Server
set up user connections	IQ”
Create an Adaptive Server IQ database	Chapter 3, “Working with Database
	Objects”
Determine appropriate indexes for	Chapter 4, “Adaptive Server IQ
your users' queries	Indexes”
Load data into your database	Chapter 5, “Moving Data In and Out
	of Databases”
Add users and assign them privileges	Chapter 10, “Managing User IDs and
	Permissions”
Ensure the integrity of data in your	Chapter 7, “Ensuring Data Integrity”
tables
Understand how transactions impact	Chapter 8, “Transactions and
concurrency	Versioning”
Set up your database for the language	Chapter 9, “International Languages
you work in	and Character Sets”
Back up and restore databases	Chapter 11, “Backup and Data
	Recovery”
Tune Adaptive Server IQ for	Chapter 12, “Managing System
maximum performance	Resources”; see also performance
	tuning hints for specific features in all
	chapters
Monitor IQ performance	Chapter 13, “Monitoring and Tuning
	Performance”
Set up and manage a multiplex	Adaptive Server IQ Multiplex User’s
configuration	Guide

Security overview

The DBA is responsible for maintaining database security. Adaptive Server IQ provides security controls by means of the privileges you can assign to users.

3