Capturing the DB user

[system]

Hi,

Please check the same discussion that is going on here:

120×120 10.4 KB

Data warehouse database is Oracle. Universe has shared login ie all sessions use the same username/password (let’s say boenterprise/boenterprise) to access warehouse database. If user1 makes a query with InfoView (logs into InfoView user1) then in Orace database the the session info in v$session shows that query is executed by boenterprise. If user2 makes a query (logs into InfoView as user2) the in database level this query is also executed by boenterprise. Is is possible to populate column …

---

Marek Chladny (BOB member since 2003-11-27)