Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

What's New in Oracle9i for Windows

Oracle9i Release 2 (9.2) New Features

Oracle9i Release 1 (9.0.1) New Features

1 Authenticating Database Users with Windows

Windows Native Authentication Overview

Windows Authentication Protocols

User Authentication and Role Authorization Methods

Authentication and Authorization Methods To Use

Oracle9i Integration with Active Directory

Task 1: Install and Configure Components

Task 2: Set Registry Parameter OSAUTH_X509_NAME

Task 3: Start and Use Oracle Enterprise Security Manager

Using Oracle9i Directory Server Features with Active Directory

Operating System Authentication Enabled at Installation

2 Administering External Users and Roles

Using Oracle Administration Assistant for Windows NT

Managing a Remote Computer

Adding a Computer and Saving Your Configuration

Granting Administrator Privileges for All Databases on a Computer

Granting Operator Privileges for All Databases on a Computer

Connecting to a Database

Troubleshooting Connection Problems

Viewing Database Authentication Parameter Settings

Creating an External OS User

Creating a Local Database Role

Creating an External OS Role

Granting Administrator Privileges for a Single Database

Granting Operator Privileges for a Single Database

Manually Administering External Users and Roles

Manually Creating an External OS User

External User Authentication Tasks on the Oracle9i Database Server

External User Authentication Tasks on the Client Computer

Manually Granting Administrator and Operator Privileges for Databases

SYSDBA/SYSOPER Authentication Tasks on the Oracle9i Database Server

SYSDBA/SYSOPER Authentication Tasks on the Client Computer

Manually Creating an External Role

External Role Authorization Tasks on the Oracle9i Database Server

External Role Authorization Tasks on the Client Computer

Manually Migrating Users

3 Administering Enterprise Users and Roles

Enterprise User Authentication

Enterprise Role Authorization

4 Storing Oracle Wallets in the Windows Registry

Storing Private Keys and Trust Points

Storing User's Profile

Registry Parameters for Wallet Storage

Oracle Wallet Manager

Oracle Enterprise Login Assistant

Wallet Resource Locator

5 Windows 2000 PKI Integration

Oracle Public Key Infrastructure

Windows Public Key Infrastructure

Microsoft Certificate Stores

Microsoft Certificate Services

Wallet Resource Locator

A Oracle Net Services Configuration

Understanding Oracle Net Services Registry Parameter and Subkeys

Oracle Net Service Subkeys

Listener Requirements

Understanding Optional Configuration Parameters

LOCAL

TNS_ADMIN

USE_SHARED_SOCKET

Advanced Network Configuration

Configuring Authentication Method

Configuring Security for Named Pipes Protocol

Glossary

Index