Home > IT Answers > AS/400 > Way to restrict by user id, permissible libraries for WRKQRY
Umponcel
5 pts.
 Way to restrict by user id, permissible libraries for WRKQRY
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
ASKED: August 3, 2011  3:55 PM
UPDATED: March 31, 2012  7:17 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

philpl1jb
 44,070 pts.
 

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

TomLiotta
 107,735 pts.
 

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
WoodEngineer
 5,525 pts.