VPD Profile not working as expected
I have written below predicate so that orders meant for specific Divsion are visible to certian people. (Order Release)
(exists (select 'x' from user_association where user_association.gl_user_gid = SYS_CONTEXT('gl_user_ctx','gl_user_gid')
and user_association.user_association_qual = 'DIVISION' and user_association.user_association_value = order_release.attribute1)
and exists (select 'x' from user_association where user_association.gl_user_gid = SYS_CONTEXT('gl_user_ctx','gl_user_gid')
and user_association.user_association_qual = 'DIVISION' and user_association.user_association_value = order_release.attribute1))
I have also done user association with DIVISION qual and value as 'ABC' .
Tagged:
0