This discussion is archived
2 Replies Latest reply: Feb 8, 2013 10:52 PM by Mahesh RSS

Grant API to user

Mahesh Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Hi EJ thanks a lot it resolved my issue

    Regards,
    mahesh

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points