Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Secure Audit Table in SQL SERVER
All of the actions take place in the dbo schema. I created audit table and appropriate insert, update and delete triggers.
But the audit team wants me to guarantee that the application user or any of the other roles within this schema cannot modfiy this audit table. I am not so good at security or roles so I am looking for an elegant solution to satisfy their requirements.
I was thinking about a linked server that contains the Audit table.
Has anyone else implemented anything similar?? Any ideas?
jharvey6