[
https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5725:
---------------------------------------
How would this have to look like? Lets assume the scenario where a
user should be able to call a virtual procedure which than calls a stored procedure.
Further, the user should not be able to call the stored procedure directly.
If a
user calls now calls the virtual procedure, would he than not need to have the same role
assigned that is required to execute the stored procedure directly?
I realized that you had a dangling question of the usage of data roles. Data roles for
access are enforced at the top level of user query. If the user has execute permission on
the virtual procedure, that is all that is required. Masking and row level security is
applied transitively. See
http://teiid.github.io/teiid-documents/master/content/reference/Permissio...
Please improve documentation on definition of stored procedures,
virtual functions and virtual procedures
---------------------------------------------------------------------------------------------------------
Key: TEIID-5725
URL:
https://issues.jboss.org/browse/TEIID-5725
Project: Teiid
Issue Type: Enhancement
Reporter: Christoph John
Assignee: Steven Hawkins
Priority: Critical
I refer to the discussion with Ramesh in
https://developer.jboss.org/message/989048#989048 and would like to ask for a more
detailed explanation on how to write virtual procedures and functions.
-Especially, how are OUT and INOUT params set and how can they be obtained via odata.
- How is the return value of a virtual function set?
- How are collections and arrays of collections returned?
--
This message was sent by Atlassian Jira
(v7.12.1#712002)