lianvh (8/2/2012)
...our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather invest in audit trail software that sends out a notification when certain userids are accessing the data ? Any ideas ?
It all depends on the technology. As far as I know it is not possible to do it (yet) on SQL Server but Oracle has a working solution for it, Oracle vault.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.