- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 10-19-2017 11:10 AM
(1512 views)
Hi, I am trying to know the user ID and the code that is associated with a modification so I ran this code , but nothing is displayed
proc sql;
select
reason_code,
_atopcode_,
_atuserid_ format=$6.,
_atdatetime_
from la_prod.ADM_GLOBAL_VARS (type=audit);
quit;
someone can help me please.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Are your sure that audit is activated for this table, and that has been changes since that time?
Please provide the log.
Please provide the log.
Data never sleeps
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@LinusH thanks for answering me !
Well I activated the audit and I made some changes and I add the variables _ATRETURNCODE_ , _ATMESSAGE_ .
it works for the datetime and the user name ! but i got nothing for _ATRETURNCODE_ and _ATMESSAGE_ .
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I can't test it right now, but my guess is that those are only populated when there is an issue, like a violated constraint or similar.
Data never sleeps