Sybase 12.4.2 Manuale Utente

Contents

Managing individual user IDs and permissions ............................  356

Creating new users ...............................................................  357
Changing a password............................................................  357
Granting DBA and resource authority ...................................  358
Granting permissions on tables and views............................  359
Granting users the right to grant permissions .......................  360
Granting permissions on procedures ....................................  361
Revoking user permissions ...................................................  362

Managing groups .........................................................................  363

Creating groups.....................................................................  363
Granting group membership to users....................................  364
Permissions of groups...........................................................  365
Referring to tables owned by groups.....................................  365
Groups without passwords ....................................................  366
Special groups.......................................................................  367

Database object names and prefixes ...........................................  367
Using views and procedures for extra security ............................  369

Using views for tailored security............................................  370
Using procedures for tailored security...................................  371

How user permissions are assessed ...........................................  372
Managing the resources connections use....................................  372
Users and permissions in the system tables ................................  374

Backup protects your data ...........................................................  377
Backing up your database............................................................  378

Types of backups ..................................................................  378
Selecting archive devices......................................................  380
Preparing for backup .............................................................  381
Concurrency and backups.....................................................  383
The BACKUP statement........................................................  383
Backup Examples..................................................................  388
Recovery from errors during backup .....................................  389
After you complete a backup.................................................  390
Performing backups with non-Sybase products ....................  390

Performing system-level backups ................................................  391

Shutting down the database..................................................  391
Backing up the right files .......................................................  392
Restoring from a system-level backup ..................................  392

Validating your database..............................................................  393

Interpreting results.................................................................  394
Concurrency issues for sp_iqcheckdb...................................  395

Restoring your databases ............................................................  396

Before you restore.................................................................  396