User creation date in repository

system · July 11, 2005, 5:40pm

Hi,
Is there anyway we can find out when user’s are created in repository?.Does any one have SQL to run a report for user’s creation date in repository.
We are running on oracle 91 and E651 .

Thanks in advance

rao (BOB member since 2003-06-02)

system · July 11, 2005, 5:48pm

I don’t have 6.5.1 here to verify, but off the top of my head, I believe there is an “actor” table (Business Objects calls the user as actor) in the security domain. If you can find the table, there should be a create date associated with each record.

Hope this helps.

substring (BOB member since 2004-01-16)

system · July 11, 2005, 6:05pm

Hi,
I don’t see any date column the in obj_m_actor table.Please advice.

Thanks

rao (BOB member since 2003-06-02)

system · July 11, 2005, 9:24pm

Does anyone have SQL to run to know when user are created in repository?.Please let me know.

Thanks

rao (BOB member since 2003-06-02)

system · July 12, 2005, 3:04am

There is the LAD (last action date) and LAT (last action taken). You should be able to look at those fields. Have a look at the repository reference (just recently posted online) in this topic:

OBJ_M_ACTOR (The “user” table)

Dave Rathbun (BOB member since 2002-06-06)