Home » Developer & Programmer » Reports & Discoverer » Hide user name , password and database name
Hide user name , password and database name [message #679866] Wed, 08 April 2020 06:01 Go to next message
haider_1pk
Messages: 111
Registered: March 2009
Location: PAKISTAN
Senior Member
Hello Friends,


Kindly guide me how i can hide user name , password and database name in oracle 10g reports.

DECLARE
rep_url varchar2(2000);
BEGIN
rep_url:='/reports/rwservlet?server=ali'
||'&report=\test.RDF'
||'&desformat=htmlcss&destype=cache'
||'&userid=user/password@databaseparamform=yes';
WEB.SHOW_DOCUMENT(rep_url,'_blank');
END;

I am using this for call report.I am forget to edit cgicmd.dat file.

Regards

Haider
Re: Hide user name , password and database name [message #679897 is a reply to message #679866] Fri, 10 April 2020 04:45 Go to previous messageGo to next message
haider_1pk
Messages: 111
Registered: March 2009
Location: PAKISTAN
Senior Member
Waiting your reply
Re: Hide user name , password and database name [message #679899 is a reply to message #679897] Fri, 10 April 2020 06:14 Go to previous messageGo to next message
Littlefoot
Messages: 21559
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
CGICMD.DAT it is. Create a row for that report in there and you'll solve the problem.
Re: Hide user name , password and database name [message #679901 is a reply to message #679899] Fri, 10 April 2020 09:57 Go to previous messageGo to next message
Gin min
Messages: 5
Registered: March 2020
Junior Member
Dear Sir. can you give me a example
Re: Hide user name , password and database name [message #679902 is a reply to message #679901] Fri, 10 April 2020 10:48 Go to previous messageGo to next message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why should he when you repeatedly violate the forum rules and refuse to help others?

http://www.orafaq.com/forum/mv/msg/206594/679784/#msg_679784

[Updated on: Fri, 10 April 2020 10:50]

Report message to a moderator

Re: Hide user name , password and database name [message #679909 is a reply to message #679902] Fri, 10 April 2020 16:12 Go to previous messageGo to next message
Littlefoot
Messages: 21559
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can remember, CGICMD.DAT - at the beginning of the file - contains help section with examples. Just open it, read it, and do as you see it.
Re: Hide user name , password and database name [message #680398 is a reply to message #679901] Tue, 12 May 2020 03:24 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,
Search the CGICMD.DAT file in your Oracle Forms & Report Installation folder.

Oracle Reports 11gR2 cgicmd.dat file is in the below path.

Quote:

C:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.1.2\configurati on

/foru/forum/fa/14319/0/
Open the cgicmd.dat file there are sample Key Entries

Quote:

/* Example 1: Run a simple breakb report and output to HTML
orqa: report=breakb.rdf destype=cache desformat=html server=repserver */

usr: userid=javausers/xyz@172.0.0.16:1522/web.alnaghi.com server=RptSvr_nis-app-admin_asinst_1 destype=cache paramform=no %*
How to use the Key Entry usr in Report URL

Quote:

http://apps.solutions.com:9002/reports/rwservlet?usr&report=Purchase_Order.rdf&desformat=pdf&OrdNo=20193427

Hope It'll help you.

Regards,
Muhammad Irfan
Previous Topic: FRM-41214: Unable to run report
Goto Forum:
  


Current Time: Tue May 26 15:34:46 CDT 2020