- 3 Posts
- 45 Views
Hi - Has anyone been successful at implementing security on prior year Workbench ID's (either W2 or ACA) so users can only view data (and not delete)? Oracle has this question in a FAQ but their answer is to ask the Tools Group. When I try and apply Row Security P00950 to either F07810 DateYr or F08210 RPYR, I receive the message: Data Item not setup for row security.
@Nancy Hilary Hi Nancy, not sure who you are attempting to keep from making changes; general users or the users generating the data in the workbenches. I'm assuming it is the users who generate the data in the workbenches.
You can enable Row Security for the data elements by editing them in the Data Dictionary and performing a Full Package Build. We don't normally do it so I don't know the risks/system impacts to making the change beyond checking the change if you apply an ESU that impacts the Data Dictionary Item or upgrade to a new version.
Hope this helps,