This content has been marked as final. Show 5 replies
Is the user a native user or an AD user, as AD users are not actually created in Shared Services only provisioned, if it is a native user then the Shared Services relational tables CSS_USER, CSS_GROUP have columns CREATEDTIMESTAMP,UPDATEDTIMESTAMP1 person found this helpful
There is also CSS_PROVISIONING_INFO which holds provisioning and has CREATEDTIMESTAMP
I would suggest the provisioning and security report in Shared Services but they are pretty limited.
Thank you very much for your answer.
The user is from active directory.
I will try and check the last tables you had mentioned.
When I look at the table CSS_PROVISIONING_INFO, I see the column MEMBER_IDENTITY. However, how do I find out what user is which as it does not say the user_name?
Join it with CSS_USERS1 person found this helpful
SELECT b.name, a.* FROM css_provisioning_info a, css_users b WHERE a.member_identity=b.identity_id;
As it is for AD users then joining to the CSS_USERS table will not help as AD information is not stored in that table, the provisioning table holds the AD ID attribute which links back to the AD.1 person found this helpful