Data role is not enforced

[ewoutv]

Hi,

in Jboss Developer Studio, I set up a VDB which I can query using JDBC without any problem using the following query:

SELECT customernumber FROM customerListViewModel.customerListView

I then added a data role to the VDB for the client user "testuser" like this:

To my surprise, testuser is still able to query the column customernumber.

I have a custom PolicyDecider set up, and commandContext.getVdb().getDataPolicies() returns nothing.

What am I missing here?

Best regards,

Ewout

[ewoutv]

Hi,

figured it out myself: I had to mark the project as deployable.

Regards,

Ewout

[rareddy]

Great, we love easy answers

BTW what did you mean by making project as deployable? In preview in Designer does not enforce the data roles, but when you deploy the vdb it does.

Ramesh..

[ewoutv]

In the Teiid Designer perspective of JBoss Developer Studio, right click on the project and then click on Mark as Deployable.

Ewout