Untitled

Try this

EXEC ('USE CIMA_ACCOUNTING; SELECT name, schema_name(schema_id) AS schema_name FROM sys.objects WHERE name = ''ADGroups'' AND type = ''U''; GRANT SELECT ON [dbo].[ADGroups] TO clawsuser; SELECT * FROM [dbo].[ADGroups]') AT cima_aws_dev;