HomeOracle 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).
The following iasdb schemas are used by the Oracle Workflow component, and the passwords may be changed as desired:
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.