]
Steven Hawkins resolved TEIID-4771.
-----------------------------------
Resolution: Done
Corrected the generated ddl. See TEIID-4770 for other changes related to grant/revoke.
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;