]
Work on TEIID-4771 started by Steven Hawkins.
---------------------------------------------
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
Fix For: 9.3, 9.2.1
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;