Run Report using server user name AND password

[mholy]

Hello all,
I'm trying to develop reports that are able to run without requiring the user to enter a database username/password in the parameters box every time they run a report (in End User Desktop). We are setting up the usernames/passwords to match their Oracle username/password accounts. Therefore what I need is a "straight-thru" way of getting the Actuate server to log in to Oracle using the users own accounts. I know there is a GetServerUserName( ) but there is no analogous GetServerPassword( ) method - about the closest I've seen to this in the manuals are the API's AcGetUserPreferences and even that does not specifically say that you can get the password. I'm hoping that there is a simple configuration or "tick-box" that I'm missing as it seems to me that this would be a fairly standard pattern of running reports. Anyone have any ideas? Help!? thank you.

 

[bcaslow]

It's helpful to know which Actuate version you are using, as the technology changed between versions 5 and 6. However, no, there is no "tick-box" to check, and the passwords are encrypted and therefore not accessible via code.

The closest you can come is not good security: you can enter a username/password at development, check the box at the bottom (Connection, Properties) which says "Parameter" and enter a username and password as default. It doesn't really solve the problem; just eliviates users typing something in.

What you're looking for is referred to as "Single Sign on" which usually involves LDAP and Java or C++. And no, I don't have an example to give you; sorry!


Bill