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

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-4800:
-------------------------------------

             Summary: Permissions should also specify object type
                 Key: TEIID-4800
                 URL: https://issues.jboss.org/browse/TEIID-4800
             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)