Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    ha noi
    Posts
    24

    Red face Unanswered: How to hide username& Pwd in URL while browse a Report?

    Hello,
    The Oracle Reports Web Publishing document
    says that to run a report over the Web the example is of the type.

    My understanding is that the user name will appear in the URL.
    My question is how do I ensure that the security info, ie. Use name and password is NOT displayed in the URL.

    I know the "FORMS90_HIDE_OBR_PARAMS" parameters, please tell me how to use.

    Thanks a lot!
    Hdninte

  2. #2
    Join Date
    Oct 2003
    Posts
    43
    Basically you can add an entry into the CGICMD.dat file on your application server. This can be found in the /reports/conf/cgicmd.dat.
    with in this you can add an entery specifying the parameters you want to hide eg.
    rhmpdf: server=server destype=cache desformat=pdf userid=user/password@database paraform=no %*

    Then if you use web.show_documents to run the report
    you can use the following URL.

    http://sunbox15/reports/rwservlet?cm...rameter1=Jones

    Referencing the CGICMD.dat entry 'cmdkey=rhmpdf'

  3. #3
    Join Date
    Dec 2003
    Location
    ha noi
    Posts
    24

    Please tell me detail of work to do!

    thank for your reply,
    howerver, please show me detail how to do.
    Firstly, show me how to add into the "cgicmd.dat", give me a sample.
    Secondly, show me how to use that mean in the forms calling the Reports what would I do? give me a sample, please!
    regards
    Hdninte

  4. #4
    Join Date
    Oct 2003
    Posts
    43
    All the infomation you will need to do this can be got from the Oracle white paper. 'Intergrating Oracle9iAS Reports Sevices in Oracle9iAS Forms Services', which you can get from the Oracle OTN network or from Metalink.

    This will basically tell you what the CGICMD.dat file is/does, how to add you details to it. Then explain how to use the web.show_document call in a form to run a report.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •