For one library WRKQRY must be prohibited.

5 pts.
Tags:
AS/400 user permissions
Work with Query
WRKQRY
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I don’t think that what you’re asking for is possible.

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following