Page 1 of 1

CreateUser and UpdateUser information

Posted: Wed Oct 16, 2013 9:21 am
by DSRajesh
Dear All,

How would i get the user information for the columns create user id and update user id in server routine.

Is there any DS macro or function can i use the server routine?

Could any one please suggest me here.

Posted: Wed Oct 16, 2013 10:39 am
by chulett
What columns are you referring to? I don't mean their names but where they live, what table(s) they are associated with.

Posted: Wed Oct 16, 2013 3:06 pm
by ray.wurlod
A Search for DS_AUDIT may reveal what you require.

Default Engine credentials may thwart your efforts.

Posted: Wed Oct 16, 2013 4:45 pm
by chulett
I suspected that might be the case but was hoping they could be more precise in their requirements statement.

Posted: Wed Oct 16, 2013 10:18 pm
by DSRajesh
These columns are from audit table which holds job statistics information.

Is there any specific basic language functions or macros which return the information for the create_user_id and update_user_id columns.

Posted: Thu Oct 17, 2013 1:36 am
by ray.wurlod
No.