Hello,

I'm trying to write a grant statement for a few hundred tables in DB2. I love doing this in Excel as it's so easy once you get the formula. Although I am having trouble with the double quotes that DB2 uses since Excel uses that to break out of a Concatenate.

Here is a sample statement: GRANT SELECT, INSERT, UPDATE, ALTER, DELETE ON TABLE "schemaname"."tablename" TO USER "JohnDoe" WITH GRANT OPTION;

schema name will be A1 and tablename will be A2. JohnDoe will be hard-coded/constant.

Any help would be greatly appreciated.