Home Forums SQL Server 2008 Security (SS2K8) Logon Triggers. A good idea? Or a nerve-racking exprience? RE: Logon Triggers. A good idea? Or a nerve-racking exprience?

  • You could also use EXECUTE AS OWNER or specify another login. I use a generic "auditor" login who owns the Audit database. That will allow it to create all of the Service Broker objects. To create the event notification the login will need CREATE TRACE EVENT NOTIFICATION permission and a corresponding user in the msdb database (no special permissions needed there, it just needs to exist).



    Colleen M. Morrow
    Cleveland DBA