[
https://issues.jboss.org/browse/TEIID-4771?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-4771:
---------------------------------------
I'm working on these changes.
We need to make several adjustments. First with the generated ddl the permission names
need to be corrected. Then it makes sense to remove the ON DATABASE and instead make
grants contextual to the current database.
Beyond that we need to use slightly different syntax to handle the LANGUAGE and ALL
PRIVILEGES grants - as they are currently not implemented against schema resources.
We also have an issue with REVOKE handling in that it attempts to match the resource - but
with the current permission system it's perfectly valid to grant access at a high
level (for example the schema) then revoke for individual tables.
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)