This content has been marked as final. Show 2 replies
Are you talking about [url http://docs.oracle.com/cd/E23943_01/portal.1111/e10238/pdg_cm_intro.htm#POBLD478]9.3 Providing Access to the APIs and Secure Views ?
In that case, you can use provsyns.sql. Notice that the instructions for obtaining the portal password apply to 10g only. If you need to get it on 11g, use the instructions in Note [url https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=843978.1]843978.1, 'How to Retrieve the Portal Schema Password in Portal 11g?'.