Q:
For one library WRKQRY must be prohibited.
Some users in my company may use the command WRKQRY. Then they can also select files from the financial library. The management want to change this. The users may select by WRKQRY all files of all libraries except the fiancial library. This library is also used by our applications and that must be still possible. Only by WRKQRY this library must be protected so that the users can not select files from this library.
ASKED:
Apr 21 2009 11:29 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
The tool you have is security. You want to secure this library with *public exclude
The application needs to run with owner authority instead of user authority and the owner of the application programs needs full authority to the library.
Phil
=============
Hi,
Maybe you could create a small CL program to do the WRKQRY command and make sure that the CL program runs under *OWNER profile and exclude the owner of the program from the financial library and objects.
Create the CL program, then use CHGOBJOWN to change the ownership and CHGPGM to USRPRF(*OWNER).
I'm not sure whether WRKQRY by-passes this sort of adopted authority or not, but it's certainly worth a try.
Regards,
Martin Gilbert.
======================
Cool - Martin's answer is closer to what you want - if it works please let us know.
Phil
