Informix Guide to SQL: Tutorial

Informix Guide to SQL: Tutorial
Chapter 11: Granting and Limiting Access to Your Database

Home Contents Index Master Index New Book

Granting and Limiting Access to Your Database

Securing Confidential Data

Granting Privileges

Database-Level Privileges

: Connect Privilege
: Resource Privilege
: Database Administrator Privilege

Ownership Rights

Table-Level Privileges

: Access Privileges
: Index, Alter, and References Privileges
: Column-Level Privileges

Type-Level Privileges

: Usage Privileges for User-Defined Types

Routine-Level Privileges

Automating Privileges

: Automating with a Command Script
: Using Roles

Controlling Access to Data Using Routines

: Restricting Reads of Data
: Restricting Changes to Data
: Monitoring Changes to Data
: Restricting Object Creation

: Duplicate Rows from Views
: Restrictions on Views
: When the Basis Changes

Creating Typed Views

Modifying Through a View

: Deleting Through a View
: Updating a View
: Inserting into a View
: Using the WITH CHECK OPTION Clause

Privileges and Views

: Privileges When You Create a View
: Privileges When You Use a View

Informix Guide to SQL: Tutorial, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.