Trying to see if sp_audit can be used to audit whether a login is connection to databaseB. It looks like only 'all' works and not a specific db/login which is what Im trying to avoid.

1> sp_audit 'login','testuser','mydb', 'on'
2> go
Msg 18222, Level 16, State 1:
Server 'SERVER', Procedure 'sp_audit', Line 240:
Object name must be 'all'.
(return status = 1)

1> sp_audit 'login','testuser','all', 'on'
2> go
Msg 18225, Level 16, State 1:
Server 'SERVER', Procedure 'sp_audit', Line 249:
Login name must be 'all'.


Saw some feature requests for this. But just want to check if there is any other method to achieve this.