EBS R12.29 - Creation of Roles and Grants for Value Sets
In R12.2.X Oracle has introduced Roles and grants to all value sets. One cannot view any values under a value set, unless a role / grant is assigned to that user.
As you know, we might have many value sets in the system. Is there an easy way to create roles for all the available value sets and assign them to users?
Right now we are creating one role for each set of value sets, i.e., GL COA segments one role, one role for each set of value sets used in a concurrent program etc. This is tedious.
Please let me know if anyone has a better & easy method.