Way to restrict by user id, permissible libraries for WRKQRY

5 pts.
Tags:
AS/400
AS/400 commands
AS/400 Library
OS/400
WRKQRY
On OS400, Is there a way to manage limitation for permissible librairies when they use the command WRKQRY? And for those limited librairies can we assign a limit or quota to the storage usage per user id ou user group to avoid creation of enourmous files? Thanks in advance for reply on that,

Software/Hardware used:
OS/400 on AS/400

Answer Wiki

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

Discuss This Question: 3  Replies

 
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
  • philpl1jb
    You can restrict who uses WRKQRY. You can restrict who can use a specific library. But I don't think there is an easy way to restrict the combination. Phil
    49,960 pointsBadges:
    report
  • TomLiotta
    Is there a way to manage limitation for permissible librairies when they use the command WRKQRY? I agree with Phil. It's fairly easy to control which libraries can be accessed by which users. And it's fairly easy to control which users can use WRKQRY. But combining the two would take work. And for those limited librairies can we assign a limit or quota to the storage usage per user id ou user group to avoid creation of enourmous files? It's also fairly easy to control how much storage various users may use up. However, it sounds like what you really need to do is to put an overall authority scheme into place. If your system doesn't have a structure in place, you will be getting into a mess by setting authorities that will be difficult to control in the future. There will be too many details that will take too much time to manage. How many libraries do you want to control? How many non-system libraries are there altogether? How many users are on your system? (Exact numbers aren't needed, but the counts should be within 10% or so.) Tom
    125,585 pointsBadges:
    report
  • WoodEngineer
    The system allows you to limit storage by user, as shown here. Maybe that will help a bit.
                            Change User Profile (CHGUSRPRF)                       
                                                                                  
    Type choices, press Enter.                                                    
                                                                                  
    Limit device sessions  . . . . .   *NO           *SAME, *SYSVAL, *YES, *NO... 
    Keyboard buffering . . . . . . .   *SYSVAL       *SAME, *SYSVAL, *NO...       
    Maximum allowed storage  . . . .   *NOMAX        Kilobytes, *SAME, *NOMAX     
    6,680 pointsBadges:
    report

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