Can not create logon trigger on AWS RDS sql server instance
0
votes
1
answer
272
views
In order to audit logins I've used before a server level trigger catching the LOGON and saving it to a table, there are endless examples to do this.
But trying to do the same on and AWS RDS sqlserver instance fails with error *Cannot create the trigger 'LogLogons', because you do not have permission.*. I've full sysadmin permission. I've read and checked other questions and sites, there are references to mysql and log_bin_trust_function_creators parameter that needs to be enabled and some other things (Can I CREATE TRIGGER in an rds DB? ) but for MS SQL Server can't find a confirmation wether server level triggers can be created or not.
Found this but is not clear if logon triggers can be created or not.
CREATE TRIGGER LogLogons ON ALL SERVER WITH EXECUTE AS 'authorized_login' FOR LOGON AS
INSERT DBA.dbo.loginaudit
DEFAULT VALUES;
--DROP TRIGGER LogLogons ON ALL SERVER;
Asked by Yaroslav
(2837 rep)
May 29, 2024, 03:15 PM
Last activity: May 29, 2024, 03:52 PM
Last activity: May 29, 2024, 03:52 PM