Have a need to restrict users from 2 views creating in db2. The views will be under the high-level db2 prefix of PRR. Only certain users should be allowed access to these.
Also, have a need to protect the data from being seen by unauthorized programs. Can this be done? Only authorized programs could access the view with the protected columns. Other programs would have no access to those fields. Is this possible to get at this level?
Looking for options to limit access to selected individuals in selected columns.
Release : 16.0
Component : CA ACF2 Option for Db2
Resource rules for DB2 are written the same as any other resource. First, you need to define the resource to the infodir. For tables and views that is 'R-DTBL'. Once you have that defined and refresh the INFODIR record you can begin writing rules.