Viewing 2 posts - 1 through 2 (of 2 total)
Thanks for the replies. I will check the DDL Triggers for auditing this and simular grants.
Unfortunately we serve a lot of third party applications on our sql server farm...
August 18, 2010 at 1:52 am
#1208338
Unfortunately the stored procedure does not fail (if executed under SQL Agent Job). If tested the scenario with following simplified stored procedure
-- Create "bad" procedure
create procedure [dbo].[spadmintest] as
begin
CREATE LOGIN [admintest]...
August 17, 2010 at 7:43 am
#1207879