OraFAQ Forum: Reports & Discoverer » Hide user name , password and database name

Home » Developer & Programmer » Reports & Discoverer » Hide user name , password and database name

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Hide user name , password and database name [message #679866]

Wed, 08 April 2020 06:01

haider_1pk
Messages: 135
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

Report message to a moderator

Re: Hide user name , password and database name [message #679897 is a reply to message #679866]

Fri, 10 April 2020 04:45

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Waiting your reply

Report message to a moderator

Re: Hide user name , password and database name [message #679899 is a reply to message #679897]

Fri, 10 April 2020 06:14

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Hide user name , password and database name [message #679901 is a reply to message #679899]

Fri, 10 April 2020 09:57

Gin min
Messages: 5
Registered: March 2020

Junior Member

Dear Sir. can you give me a example

Report message to a moderator

Re: Hide user name , password and database name [message #679902 is a reply to message #679901]

Fri, 10 April 2020 10:48

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Hide user name , password and database name [message #680398 is a reply to message #679901]

Tue, 12 May 2020 03:24

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

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

Attachment: Reports11gR2.png
(Size: 138.93KB, Downloaded 2635 times)

Report message to a moderator

Previous Topic:	FRM-41214: Unable to run report
Next Topic:	Oracle ap invoice aging report custom one

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 18:22:52 CST 2025