Try this on each dbs:USE [Datasae1]

GO

EXEC sp_addrolemember N'db_ddladmin', N'testuser'

EXEC sp_droprolemember N'db_owner', N'testuser'

GRANT EXECUTE TO testuser

You have to do it on each DB since you handle the DB security at the DB level 🙂