We create a Login account for each database on our server. I have been tasked with adding Auditing to all of our databases and my plan was to create a separate database and store all auditing information there for whenever a stored procedure fails. Problem is that the stored procedure is executed by an account that has access to just one database.
Is there a way to easily grant access to all user accounts to the Audit database or can I create a trigger that executes statements using a specific user account which will have access to my auditing database?