You’re offline. This is a read only version of the page.
How can you know which user deleted which data in dynamics nav ?
*This post is locked for comments
Hello Muleso
You can do this by enabling the Change Log Setup to enable it please refer to the below screenshot.
Just follow the steps 1-4
in the change log setup, you need to activate it by ticking the option "Change Log Activated" then from the Action tab click on the Tables.
When you do that below Screen Shot will appear
On this page, you will see all the tables available in Navision for Tracking Changes. & you have tracking log for below activities.
1. Tracking on Insert
2. Tracking on Modify
3. Tracking on Delete.
Since your requirement is to track deleting you can use the delete column as I highlighted in the screenshot 2. from there you can track for All fields or you can specify which felids by selecting the option of "Some Fields" from the Drop down.
besides the drop down arrow, you will see "..." button and when you click it as shown in the screenshot no2 you will be able to select what fields you need to track on selected table for delete.
I recommend you this option because it will be put less weight on your system rather than tracking all the fields wich will increase the size of your database over the period of time.
Hope this will help you to resolve your problem
Thanks
Indika.
Muleso,
Please check below links, if those of any help to you.
https://msdn.microsoft.com/en-us/library/hh169208(v=nav.90).aspx
http://www.archerpoint.com/blog/Posts/setting-change-logs-microsoft-dynamics-nav-2013
-Yogesh Kulkarni
Please verify, if you find answer helpful.
This was insightful
Any step to step guide ?
I do think Dynamics NAV have a good security system and a good tracking system as well. It is all about how it is been set up. Any good system will look bad if that has been setup incorrectly.
If the Permission Sets, User Personalization, Change Log, NAV Service, SQL DB, security is setup "properly" then NAV will be a very secure system. Plus client license MUST use.
Coming back to the question : If the client license is used for the DB then system will not allow any user to delete posted transactions, any if a any master has open entries then those masters will not be able to delete.
If the change log is activated, then any change happen in the Dynamics NAV (up to field level) can be track back easily.
However, when activating the change log it is very necessary to consider the performance of the system.
You can activate change log for recording activities from user
Dear muleso ,
As i know Dynamics have give less priority for user controls , so that you don't have any direct access or any program to view these kind of user changes.
there are some several ways to track these kind of issues
1. Change log entry
this program can be recorded every single changes that has been done to system , but enabling and using this will effect (enable change log entry to multiple) data base and system will get stuck when u try to view(u can view but take time)
Note : if you didn't enable this to relevant program yet , so sorry u cannot view previous data
2. User permission set
maintaining permission set you can capture the user group , but you cannot capture exact person who delete it
3. DB level
strongly recommend if you don't have knowledge to database level and Dynamics development , Please get help from your organization experts
you can go for the tables and find exact table code , go to db and check whether about the changes
Please verify the answer, if it helps to resolve your issue.its might be help to others
There are limited options of deleting the data in NAV itself, and users cannot delete posted data - mainly master data or unposted documents. For those, you can setup standard chang log: msdn.microsoft.com/.../hh169208(v=nav.90).aspx
Change log would not work if someone would delete data directly in the SQL database. To log these, you need to use SQL tools.
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
