How to pass security helper to teiid embedded server/configuration

[capoorhimanshu]

Hi ,

I am providing a connection factory to the teiid embedded , which in turns is used by a source model getting deployed in VDB. When i execute the query on top of VDB exceptions are thrown from my framework ,  that its not authorized to access the resource. I was wondering why deployment is successful where it uses the same connection to fetch the meta data.

I debugged further and found that deployment is successful because it do not spawns a thread and asks for the connection in current thread , which is authorized (have security context) to access the connection but in case of executing a query teiid spawn the separate thread for each query and since that thread do not have security context to access the connection so exception is raised from my framework. Is there is any way where i can pass/attach  the security context of my framework to teiid embedded so that when the execution thread go fetch the connection it has right to do so .

Thanks

Himanshu Kapoor

[shawkins]

You have a couple of options.

If you want everything to run in the calling thread, then you can set EmbeddedConfiguration.userRequestSourceConcurrency to 1.  This tells the engine to just let the processing thread handle the source queries, which for a local connection will be the calling thread.

To use the SecurityHelper, there is EmbeddedConfiguration.setSecurityHelper.  You'll want to look at the JBossSecurityHelper to get an idea of the implementation:  teiid/jboss-integration/src/main/java/org/teiid/jboss/JBossSecurityHelper.java at master · teiid/teiid · GitHub