The Oracle Application Server 10g Infrastructure - Workflow iasdb Schemas

(Page 3 of 11 )

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
KWALKER	Workflow component	kwalker
SPIERSON	Workflow component	spierson

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.

Next: Viewing the Whole iasdb Instance >>
 

More Oracle Articles
More By McGraw-Hill/Osborne

Comments On: The Oracle Application Server 10g Infrastructure

>>> Be the FIRST to comment on this article!

Buy this book...

This article is excerpted from chapter two of Oracle Application Server 10g Administration Handbook by John Garmany and Donald Burleson(McGraw-Hill/Osborne, 2004; ISBN: 0072229586). Check it out at your favorite bookstore. Buy this book now.