[teiid-issues] [JBoss JIRA] (TEIID-4771) The convert script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.
Steven Hawkins (JIRA)
issues at jboss.org
Tue Feb 28 16:28:00 EST 2017
[ https://issues.jboss.org/browse/TEIID-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
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;
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
More information about the teiid-issues
mailing list