Shell Programming and Scripting

A
B
C
D
E
F
...
...
Z

Joe
Bob
Mary
Sally
Fred
Elmer
David

grant select on TABLE A to user Joe
grant select on TABLE B to user Joe
grant select on TABLE C to user Joe 
grant select on TABLE D to user Joe 
grant select on TABLE E to user Joe
....
grant select on TABLE Z to user Joe

grant select on TABLE A to user Bob
grant select on TABLE B to user Bob
grant select on TABLE C to user Bob
grant select on TABLE D to user Bob
....
grant select on TABLE Z to user Bob

awk '
FNR == NR {
	t[nt = NR] = $0
	next
}
{	for(i = 1; i <= nt; i++)
		print "grant select on TABLE", t[i], "to user", $0
}' file1 file2

grant select on TABLE A to user Joe
grant select on TABLE B to user Joe
grant select on TABLE C to user Joe
grant select on TABLE D to user Joe
grant select on TABLE E to user Joe
grant select on TABLE F to user Joe
grant select on TABLE ... to user Joe
grant select on TABLE ... to user Joe
grant select on TABLE Z to user Joe
grant select on TABLE A to user Bob
... abbreviated ...
grant select on TABLE Z to user Elmer
grant select on TABLE A to user David
grant select on TABLE B to user David
grant select on TABLE C to user David
grant select on TABLE D to user David
grant select on TABLE E to user David
grant select on TABLE F to user David
grant select on TABLE ... to user David
grant select on TABLE ... to user David
grant select on TABLE Z to user David