SQL Server Logon Triggers: What Permissions Are Needed
Posted on 2013-11-11
I am creating a SQL Server Logon Trigger. Once it was enabled, I could not logon to the system:
Logon failed for login 'xyz' due to trigger execution.
Changed database context to 'Master'.
Changed language setting to us_English (Microsoft SQL Server, Error: 17892)
I disabled the trigger.
I believe my issue to be related to permission on database objects. The trigger reads from a table, and inserts some information in another table. These tables are in database ABC, not the master database.
What objects do I need to give permission to? The tables? The database? And who gets the permission? Public? Guest?
Thanks In Advance,