How to prompt for database credentials for Universe during run-time?

Greetings,

We are using BO 3.1 SP2 with databases on Oracle 10g.

We are working on upgrading to Oracle 11gR2 and enable end-to-end SSO to oracle using kerberos and active directory but that is a few month down the line. Right now we use Oracle credentials to log-in to the database.

We have for strict data security policies. We have huge amounts of confidential data that only specific users can view.

We require that users of universes are prompted for their database credentials during run-time when using web intelligence.

How can we do that?

Note: Generic database credentials or service accounts are not an option.

We are trying to promote WEBI to our wide user base and this is a major obstacle for us.

Thank you for your help.

Regards,

Hassan