Is there a way to notify the administrator if a user level eg accounts receivable user has accessed a particular field from a table?
*This post is locked for comments
Is there a way to notify the administrator if a user level eg accounts receivable user has accessed a particular field from a table?
*This post is locked for comments
Hi,
The word 'accessed' might have two meanings. It could mean they have retrieved the value on e.g. a form or really modified the contents.
I assume you meant the updates. If it is updated, you can use the alert functionality like Nitesh mentioned. Another option is to use Database logging.
technet.microsoft.com/.../dd362089.aspx
Note that database logging and alerting can slow down the performance when many records from tables are inserted or updated with e.g. a periodic job. The performance impact is described lately in a blog and can be found here: blogs.msdn.com/.../performance-impact-of-sysdatabaselog.aspx
I suggest you should create a alert notification for field in the table
Please review following link if this helps you
Hi,
you can build a report to list users and their permissions .
Regards,
Bilal
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156