Check for membership in any of the deny roles - there may be an explicit deny being applied for those tables.
Also - check the users default schema.  If it...

If the tables are actually heaps - that is, they do not have a clustered index - then deleting data will leave unused space allocated to that table.  You can...

It isn't clear on what you are trying to calculate - what are the expected results and how does the overlap figure into the results?  It seems that you only...

You don't need to deny privileges to the user in D2 - which is being done by adding the user to the deny roles.  Once you grant execute permissions on...

I suspect some type of permissions issue is causing the script to fail.  You might have better luck using a Script Component and PowerShellInstance.  This article outlines how to implement...

I would create separate folders in the catalog - one for each source system (or some other logical break out).  You can then set different permissions on each folder if...