Specifying permissions in VDB

[brentonc]

What's the best way to specify schema permissions for a VDB?

I need to add security constraints to the Virtual tables but the Designer (7.0.0) doesn't  support this in the editor, and for some reason Teiid won't accept the VDB if I expand it to edit the vdb.xml file manually.

If I unzip a valid vdb file and then try to deploy the resulting folder structure, Teiid complains:

00:04:09,597 ERROR [RUNTIME] Invalid VDB file deployment failed 345088325.INDEX
00:04:09,599 ERROR [RUNTIME] Invalid VDB file deployment failed 964163747.INDEX
00:04:09,658 ERROR [RUNTIME] Failed to load metadata for VDB xyz.1
00:04:09,659 ERROR [AbstractKernelController] Error installing to Real:  name=vfsfile:/opt/jboss/jboss-as/server/teiid/deploy/my_VDB/META-INF/vdb.xml  state=PreReal mode=Manual requiredState=Real

[rareddy]

The easiest way is to use Designer > 7.1 for defining the data-roles in a VDB. As I last heard, it is going to released in next day or two. may be you can try one of their milestone builds available right now. But you can also had edit the "vdb.xml" for providing the necessary xml content. See "Data Roles" chapter in the Reference Guide.

Can you attach the VDB, so that I can see what is the issue?

Thanks

Ramesh..

[brentonc]

Resolved.  The corrupted vdb arose because the archiving process was scoping the contents of the archive beneath a root level directory.  Hence the deployer couldn't find the META-INF directory or subsequently the vdb.xml.

Looking forward to Teiid 7.1 Designer which hopefully means no more file editing by hand.

[rareddy]

Designer team today put out a 7.1 CR1 release check it out https://www.jboss.org/teiiddesigner/downloads.html

Ramesh..