Oracle Database Username and Password?

[Guest_imported]

I'm using a table in my report from an Oracle Database. I wrote this report with a Username and Password that have a lot more access that I want the user(s) of the report to have. Is there any way to pass or embed the username and password in the report and not have to ask for it every time the report is run?

Thanks.

 

[kenhamady]

If you launch the report from an application, and you can embed it in the code.

I don't know how, but I have heard that an ODBC connection can have a UID/PWD stored as part of the connection. Of course, that might bring up other issues. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[siri]

hi tudorg!!!!!
if you generate the report from an application for example from a html page,we can solve it by writting it in the code itself.

for example:
<input type=&quot;hidden&quot; name=&quot;user0&quot; value=&quot;XXXX&quot;>
<input type=&quot;hidden&quot; name=&quot;password0&quot; value=&quot;XXXXX&quot;>

note:you should specify username as user0 & password as password0.