[teiid-issues] [JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

[Steven Hawkins (Jira)]

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

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/Permissions.html

> 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)