Yes, Teiid supports what we call "data roles". Based on the authorization group of your users, you can define different different policies/permissions for data access. See https://docs.jboss.org/author/display/TEIID/Data+Roles
There is also an example in kit in "docs/examples" on this.
Can i do something like this ?
No, this is a up to column level security. Based on this, you can either grant or deny access to a given table, procedure or column in table, not if column value is say '600015'
What you are looking for is "row" level security. This is not configurable, however Teiid does support a security function called "hasRole", see https://docs.jboss.org/author/display/TEIID/Security+Functions, using this function you can write a virtual procedure, where you can inspect the data along with "hasRole" to return the data or throw error. See this on how to write virtual procedures https://docs.jboss.org/author/display/TEIID/Virtual+Procedures
Also, you can use Teiid Designer to help with design of the VDB. This helps in defining the data roles on vdb and also writing of virtual procedure.
Do dynamic vdb's support virtual procedures ?