DATA Step, Macro, Functions and more

Enhanced Audit Logging

Accepted Solution Solved
Reply
Contributor
Posts: 28
Accepted Solution

Enhanced Audit Logging

Hi,

 

Could someone please help me with below query ?

 

How to turn on auto audit logging feature in Base SAS for data/schema creations / modifications / deletions for data-sets in permanent libraries ?

 

Note : Topics related %LOG4SAS and auto-macro-call features didn't help me much with above requirement.

 

Example :

There is a SAS data-set named "A" in a permanent library "P1". Many users can run data/schema-alteration queries on that data-set in a given day based on appropriate access levels.

 

I would like to collect the activity log which contains details of any data/schema change that includes all modifications/deletions on that data-set at the end of the day so that it would be easy to track who did what.

 

 


Accepted Solutions
Solution
‎02-21-2018 10:03 AM
PROC Star
Posts: 500

Re: Enhanced Audit Logging

Posted in reply to nrk1787db1_gmail_com

here is one good paper

 

https://www.lexjansen.com/scsug/2009/Minh_Duong.pdf

 

and documentation

 

https://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a001224397.htm

 

 

what do you think is missing in this documentation or article

 

View solution in original post


All Replies
Solution
‎02-21-2018 10:03 AM
PROC Star
Posts: 500

Re: Enhanced Audit Logging

Posted in reply to nrk1787db1_gmail_com

here is one good paper

 

https://www.lexjansen.com/scsug/2009/Minh_Duong.pdf

 

and documentation

 

https://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a001224397.htm

 

 

what do you think is missing in this documentation or article

 

Contributor
Posts: 28

Re: Enhanced Audit Logging

Thank you

Occasional Contributor
Posts: 7

Re: Enhanced Audit Logging

Posted in reply to nrk1787db1_gmail_com
Could you help me with a script to obtain the tables or data set that each user consults in metadata or data data in sas?
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 88 views
  • 0 likes
  • 3 in conversation