Skip to Main Content
  • Questions

  • Reports - web.show_document userid password contains character .#

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Ricardo Alberto.

Asked: August 04, 2017 - 11:42 pm UTC

Last updated: September 03, 2017 - 3:37 am UTC

Version: web.show_document

Viewed 1000+ times

You Asked

We use web.show_document to view reports and there are users who have a # character in their password. For these users comes a message rep-0501, for the other users who do not have that character in their password everything works fine. Here I show the url.
Http: //server+report=dlypurge.rep+userid=user/passw1.#@DATABASE+destype=cache+desformat=pdf+paramform=yes+p=0
Note that the userid contains a password with the character 1. #
For those users a message appears rep-0501

Error: The requested URL was not found, or cannot be served at this time.
Oracle Reports Server CGI - Report Job has terminated with error.
Reports Server Replies:




REP-0501: Unable to connect to the specified database.

and Connor said...

I'll suggest something different - passwords on the URL is a bad idea when it comes to security. The last thing I want is my password floating around in the browser history.

Options
- use the cgicmd.dat file
- use SSL
- omit the username and it will be prompted for.

Details on these can be found in MOS notes:

763693.1
150701.1
68255.1
104175.1
156353.1

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Support

A reader, August 05, 2017 - 1:49 am UTC

I does not have support account so how can i see document you mention above?
Connor McDonald
August 06, 2017 - 8:05 pm UTC

So you dont have a production Oracle database ?


A reader, August 07, 2017 - 9:40 am UTC

no I used Oracle database for my learning purpose and my organization does not use Oracle database.
Connor McDonald
August 07, 2017 - 8:31 pm UTC

OK, if you're just learning, the easiest way would be to change the password so that it does not contain the hash.

wev.show_document -- frmrwinteg608.jar

Ricardo Alberto Franklin, August 31, 2017 - 9:34 pm UTC

I have searched for several solutions, however, there is one that is done by cookies, for this I need to download the file frmrwinteg608.jar for the version forms and reports 6i.

http://www.oracle.com/technetwork/developer-tools/forms/documentation/secure-webshowdoc-rep6i-133956.pdf


Connor McDonald
September 03, 2017 - 3:37 am UTC

You mean ... that whitepaper which is 13 years old :-)
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.