How do I create a synoymn for self registration on Oracle 9iAS?
• Create a new schema (i.e. a new user). We’ll call the new user “registrar”: create user user registrar identified by registrar default tablespace users • Login to sqlplus as registrar • create a synonym for login server SSO schema package wwsso_api_user_admin: create synonym wwsso_api_user_admin for portal30_SSO.wwsso_api_user_admin • login to sqlplus as portal30_SSO • grant execute privileges on wwsso_api_user_admin to registrar: grant execute on wwsso_api_user_admin to registrar • At a Unix shell, under $ORACLE_HOME/portal30/admin/plsql: portal30 -p portal30 -ua registrar • Start the portal, click on the Administrator tab on the portal home page, select the Services portal, click Global Settings. Under self-registration, select “Enable Users to Log On Immediately”. Save the change. • To use the self-registartion, the portal login will need to be customized to include a self-registration link 4.5 How to setup Fetchmail to forward popped messages to an SMTP server, and throw away any