The convert script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail. ----------------------------------------------------------------------------------------- Key: TEIID-4771 URL: https://issues.jboss.org/browse/TEIID-4771 Project: Teiid Issue Type: Bug Components: Build/Kits Affects Versions: 9.2 Reporter: Bram Gadeyne Assignee: Steven Hawkins The script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail. Apparently the script does accept TEMPORARY TABLE (without the underscore). I also had to explicitly state the database name otherwise I get a message "TEIID31231 Database null.{1} not found". So this doesn't work: GRANT TEMPORARY_TABLE ON DATABASE TO rouser; But this does work: GRANT TEMPORARY TABLE ON DATABASE vdb TO rouser;