Home | Previous Page | Next Page   Managing Databases >

Granting and Limiting Access to Your Database

In This Chapter
Using SQL to Restrict Access to Data
Controlling Access to Databases
Granting Privileges
Database-Level Privileges
Connect Privilege
Resource Privilege
Database-Administrator Privilege
Ownership Rights
Table-Level Privileges
Access Privileges
Index, Alter, and References Privileges
Under Privileges for Typed Tables (IDS)
Privileges for Table Fragments (IDS)
Column-Level Privileges
Type-Level Privileges
Usage Privileges for User-Defined Types
Under Privileges for Named Row Types
Routine-Level Privileges
Language-Level Privileges
Automating Privileges
Automating with a Command Script
Using Roles
Determining Current Role at Runtime
Using SPL Routines to Control Access to Data
Restricting Data Reads
Restricting Changes to Data
Monitoring Changes to Data
Restricting Object Creation
Using Views
Creating Views
Typed Views (IDS)
Duplicate Rows from Views
Restrictions on Views
When the Basis Changes
Modifying with a View
Deleting with a View
Updating a View
Inserting into a View
Using the WITH CHECK OPTION Keywords
Re-Execution of a Prepared Statement When the View Definition Changes
Privileges and Views
Privileges When Creating a View
Privileges When Using a View
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]