2 Replies Latest reply: Feb 9, 2013 12:52 AM by Mahesh RSS

    Grant API to user

    Mahesh
      Hi Team

      can someone tell me how we can grant Oracle API to user, really appreciate help.

      Regards,
      Mahesh
        • 1. Re: Grant API to user
          Erik Janssen-Oracle
          Mahesh,

          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?'.

          Thanks,
          EJ
          • 2. Re: Grant API to user
            Mahesh
            Hi EJ thanks a lot it resolved my issue

            Regards,
            mahesh