Home > IT Answers > AS/400 > AS400 Query Security
Clhalfa
30 pts.
 AS400 Query Security
AS/400 Permissions, AS/400 Query, AS/400 Query Security, AS/400 security
How can I secure an AS400 query allowing only two individuals the ability to change or delete the query?

Software/Hardware used:
ASKED: March 3, 2009  3:01 PM
UPDATED: March 4, 2009  2:44 PM
RELATED QUESTIONS
Answer Wiki:
Hi, If you have object level security switched on then you can use GRTOBJAUT and RVKOBJAUT to grant the authority to the 2 users and revoke the authority from *PUBLIC. You can also do this by doing a WRKOBJ and option 2. Regards, Martin Gilbert. Alternatively : Use EDTOBJAUT (Edit Object Authority) Set PUBLIC to *USE (or whatever level you desire) and Set the two user profiles to *CHANGE or *ALL as appropriate.
Last Wiki Answer Submitted:  March 3, 2009  4:36 pm  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts. , KSoniat   610 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

Thank you for your timely response. I was able to find the correct individual within my organization to get this set up. I really appreciate your help with this issue.

Clhalfa
 30 pts.