BusinessObjects Board

User creation/modified date

security Supervisor (4.x - 6.x)
#1

hi
I’m trying to see if there’s a way to figure out when a user was added to the Repository. The closest thing I found for user creation date thing is M_ACTOR_N_LAD - last action date?
my question is how do I access this table? where is it stored? and what will be the path to this table. Also, do I need to run any SQL to get the user creation date for a perticular user or group?

Thanks
Meettaurus

meettaurus (BOB member since 2005-03-10)

#2

Hi,

For more information have a look to this post

You can’t know when the user was created ! it’s not stored in the repo !!

Regards

#3

Hi
I looked into that information, but how do I use it?
against what do I run the Sql mentioned there?
meettaurus

meettaurus (BOB member since 2005-03-10)

#4

You need to know where your repository, more specifically your security domain is located. That’s where the tables exist that you are going to be looking at.

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

#5

Hi Dave
Which qyuery do I need to run against those tables?
Thanks
Meettaurus

meettaurus (BOB member since 2005-03-10)

#6

Hi,

As i told you before you can’t know when the user was created ! it’s not stored in the repo !!

Regards