AS400 Query Authority
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
December 5, 2011 5:53 PM
UPDATED:
March 17, 2012 6:41 AM
Answer Wiki:
It would be a good idea to print screen or jot down some notes on the ones you have created.
My two bits...
To see all answers submitted to the Answer Wiki: View Answer History.
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
WRKOBJOWN might be of some help in identifying those items owned by you and/or your group profile.
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.