[teiid-issues] [JBoss JIRA] (TEIID-4771) The convert script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13367800#comment-13367800 ] 

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)