]
Steven Hawkins updated TEIID-2167:
----------------------------------
Fix Version/s: 9.3
Now that we have this support in DDL it will be good to at least add the information to
the xml/runtime format for round tripping purposes. It would still be optional though in
the vdb.xml
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.