Architecting, installing and maintaining your SAS environment

Audit Trail

Reply
Occasional Contributor
Posts: 13

Audit Trail

[ Edited ]

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. 

Super User
Posts: 5,490

Re: Audit Trail

Are your sure that audit is activated for this table, and that has been changes since that time?
Please provide the log.
Data never sleeps
Occasional Contributor
Posts: 13

Re: Audit Trail

@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_ .

 

Super User
Posts: 5,490

Re: Audit Trail

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
Ask a Question
Discussion stats
  • 3 replies
  • 226 views
  • 2 likes
  • 2 in conversation