[teiid-issues] [JBoss JIRA] (TEIID-2167) Permissions should also specify object type

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2167:
---------------------------------------

It's in the docs and is defined by DataPolicy.ResourceType.  Will you want something beyond that?

> Permissions should also specify object type
> -------------------------------------------
>
>                 Key: TEIID-2167
>                 URL: https://issues.jboss.org/browse/TEIID-2167
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.3
>
>
> Teiid permissions only specify a resource name.  However it is possible to have to have conflicting schema/table (since we are using non-sql safe unquoted names) or table/procedure names.
> Ideally we would use proper sql names (this is true everywhere, not just in permissions) and specify the object type (TABLE, PROCEDURE, SCHEMA, LANGUAGE, FUNCTION, etc.).  This would also allow us to have a more standard USAGE permission, rather than something like LANGUAGE, which is used to convey the permission and object type.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)