Home arrow Oracle arrow Page 3 - The Oracle Application Server 10g Infrastructure

Workflow iasdb Schemas - Oracle

If you need to handle the administration and management of Oracle Application Server 10g, this article covers the metadata repository (iasdb), the Single Sign-On (SSO) security framework, and the Oracle Application Server 10g Management Services. It is excerpted from chapter 2 of the book, Oracle Application Server 10g Administration Handbook, written by John Garmany and Donald Burleson (McGraw-Hill/Osborne, 2004; ISBN: 0072229586).

  1. The Oracle Application Server 10g Infrastructure
  2. The Infrastructure Repository
  3. Workflow iasdb Schemas
  4. Viewing the Whole iasdb Instance
  5. The Infrastructure Log Tables
  6. Writing Your Own Infrastructure Repository Log Scripts
  7. Infrastructure Log Reports
  8. Repository Administration and Management
  9. Single Sign-On (SSO)
  10. Using the SSO Audit Log Tables
  11. SSO Administration Using the mod_osso Utility
By: McGraw-Hill/Osborne
Rating: starstarstarstarstar / 12
May 05, 2005

print this article



The following iasdb schemas are used by the Oracle Workflow component, and the passwords may be changed as desired:

Schema Name


Used By

Default Password

BLEWIS Workflow component blewis
CDOUGLAS Workflow component cdouglas

Workflow component


Workflow component


Schemas Registered in the OID

The next group of iasdb schemas includes those that are registered in OID. Because the OID manages the passwords for these schemas, you should never attempt to alter any of these schema owner passwords with the alter user command. Instead, you should use the OEM facility for changing these passwords. When using OEM to alter these passwords, OEM will change the password inside the iasdb database and also update the appropriate OID system tables.

OID Schema Name                   Used By
DISCOVERER5                       Discoverer
DSGATEWAY                         Syndication Server
DSSYS                             Web Services
ODS                               Internet Directory
ODSCOMMON                         Internet Directory
ORASSO                            Single Sign-On
ORASSO_DS                         Single Sign-On
ORASSO_PA                         Single Sign-On
ORASSO_PS                         Single Sign-On
ORASSO_PUBLIC                     Single Sign-On
PORTAL                            Portal
PORTAL_APP                        Portal
PORTAL_DEMO                       Portal
PORTAL_PUBLIC                     Portal
WIRELESS                          Wireless

Now letís go deeper and explore SQL*Plus scripts that allow you to see the individual schema components in greater detail.

>>> More Oracle Articles          >>> More By McGraw-Hill/Osborne

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates


Dev Shed Tutorial Topics: