Untitled

EXEC ('USE [CIMA_ACCOUNTING]; GRANT SELECT ON [dbo].[ADGroups] TO [clawsuser]') AT cima_aws_dev;

EXEC sp_droplinkedsrvlogin @rmtsrvname = 'cima_aws_dev', @locallogin = NULL;
EXEC sp_addlinkedsrvlogin @rmtsrvname = 'cima_aws_dev', @useself = 'False', @locallogin = 'sa', @rmtuser = 'clawsuser', @rmtpassword = 'password';