AS400 Query Authority

5 pts.
Tags:
AS/400 security
If I created a query am I considered the "owner"?? If I use *exclude, does this keep everyone except me from accessing/changing/deleting the query? Explaining why I ask these questions, might help. We use an AS400 software that is hosted by a software company. They have the server, not us. We are changing software companies to another company. I want to make sure they can not limit my access to queries I have built, which I have heard they have done to others to force them to pay high conversion fees. It might be important to note that I do not have security officer authority (so no command line prompts) and they do.

Answer Wiki

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

It would be a good idea to print screen or jot down some notes on the ones you have created.

My two bits…

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
  • TomLiotta
    If I created a query am I considered the "owner"?? Maybe, but there's no way to know without seeing how that attribute is defined for your user profile. Do you know if your user profile has been assigned group membership? And, of course, there's probably no way at all to know what their system software does with newly created objects. If the system is operated by someone else, they can make it work however they choose within their programming capabilities. Tom
    125,585 pointsBadges:
    report
  • Splat
    WRKOBJOWN might be of some help in identifying those items owned by you and/or your group profile.
    7,455 pointsBadges:
    report
  • NickHutcheson1
    You could get a list of the ones that you and/or your group profile owns then WRKQRY then take option 6 beside all that you own. This will print the description. Hopefully, you can either actually print them or go into iSeries Navigator and drag all of your newly created spool files to your desktop or a folder somewhere. Then delete the spool files. These being on 'their' system, I would say they can change authorities anytime they wish and/or move the query objects to another library that you cannot access. You can always say that you are documenting all of the queries if any questions come up as to why you are printing all of the descriptions. I hope this helps.
    1,380 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