How can i link a oracle user to a business objects user

Posted by Robert Speckmann on Server Fault See other posts from Server Fault or by Robert Speckmann
Published on 2010-03-26T10:21:35Z Indexed on 2010/03/26 10:23 UTC
Read the original article Hit count: 570

I have a problem with linking the oracle user to a business objects user. I will try to explain it as detailed as possible;

I have a Oracle database (10g) where a couple of users are defined. These users can query on information with application X. Those records will then be written into the oracle database. The records that is written into the database has a ID that links to the person that has run the query.

I also have a active directory in wich a couple of users are made; testuser1, testuser2. When those users log on, and want to load a report in Business Objects XI i want them to see the information that was created when the report was activated by that same user that had runned the query before with application X. The name of the person in the active directory and the name in the oracle database are not the same but i dont think that would be a problem in this stage.

So the steps i took:

  • First, i run a report in application X (with a account prodpim_rs) wich fills my Oracle database with a record.
  • The second step is logging on as testuser1 (from the AD) and then login on Business Objects XI with the account. Now i want to load a report with the information in my Oracle database. So the prodpim_rs user and the testuser must have a link between them.

I am wondering how to forfill this. Can i link the account, wich is made in a Oracle database, with the user of BO wich is linked to my AD?

Thank you in advance for your reply

Robert

© Server Fault or respective owner

Related posts about Oracle

Related posts about businessobjects