Hi Jdbcag
We are also using inclusive row security and need help.
We have a requirement that one security group should be able to add/modify and view UDCs with product code 00, But it can view all UDC values. So I defined 1 records for row security with following information
Table Data Item From To Add Modify Delete View
F0004 ProductCode 00 00 Y Y N Y
Now user corresponding to this group can only see UDC with product code 00 but can not view UDCs with other product code. I am thinking of adding new record with view rights only for this security security( It seems to me it is necessay as inclusive security, user can access only records definded in security workbench).
Now my question is
1. What should be the value of "From Value" and "To Value" so that it covers all the product codes whether these start with Numberic or alpha characters? Does it depend upon database character set.
Any help is appreciated.