Which table is used ?

server administration Web Intelligence 6.x Servers
1

In BOMgr, it’s possible to see which InfoView Users are connetced (this is the login BO displayed).

My question is : where does this information come from ?

Our repository is Oracle. I see nothing excepted the Full/Client, in the sys.v_$session table.

PS : we have no audit modul installed ??? so I don’t understand where does this information come from ? a table ?

Thank’s for your answer ?

Ty_Bou :fr: (BOB member since 2005-02-16)

2

Hi,

I think the IIS (or whatever webserver) server will hold that information.
(sessions)

Regards,

Gerard

highandstoned :netherlands: (BOB member since 2005-08-01)

3

I don’t understand your answer.

You mean, there is no information in the database (Oracle for us).

Ty_Bou :fr: (BOB member since 2005-02-16)

4

Hi,

  1. when you use auditing, you can see it (allthough not realtime)
  2. depending on you security settings, but the most probable answer is that you web server is creating the connection to the oracle database and the end user only has his http connection to the web server. So, no with webi, you can’t see in oracle which user is connected (just that the webi server has a connection). Only when you use the BO user name to login to the database would you be able to see it.

Regards,

Gerard

highandstoned :netherlands: (BOB member since 2005-08-01)