Accessing STRSQL

145 pts.
Tags:
AS/400
STRSQL
Can granting access to limit capabilities *partial or *no will give user the access to STRSQL?

Software/Hardware used:
as400, iseries
ASKED: October 23, 2012  9:36 AM
UPDATED: October 23, 2012  2:09 PM

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: 6  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
    It possibly can. But it's not needed. What exactly are you trying to accomplish? -- Tom
    125,585 pointsBadges:
    report
  • 100282
    One business user complained that he doesnt have access to STRSQL.. My question is do we need to grant access to STRSQL command object also along with the limit capabilities as *PARTIAL or *YES?
    145 pointsBadges:
    report
  • TomLiotta
    One business user complained that he doesnt have access to STRSQL.   Then it is very likely that the user should not have access to STRSQL. If the user is a limited-capability user, there should be no access to STRSQL. If the user really needs STRSQL, then the user probably shouldn't be a limited-capability user.   My question is do we need to grant access to STRSQL command object also along with the limit capabilities as *PARTIAL or *YES?   That depends on why there is no access to STRSQL. Is it because of limited-capability or authority to the command? Is the command set as ALWLMTUSR(*YES)?   Regardless, you can alway put STRSQL into a CL program and let the user run the program, perhaps through a command that is set as ALWLMTUSR(*YES) and authorized through an authorization list that only has that user listed.   But I'd probably just let the user run STRQM rather than STRSQL. Much safer and much more control is available.   Tom
    125,585 pointsBadges:
    report
  • ToddN2000
    The only reason they would need to have access to STRSQL is to maintain the data. If they want to extract data the take Tom's advice and have them use STRQM.
    6,360 pointsBadges:
    report
  • TomLiotta
    ...access to STRSQL is to maintain the data.   It needs to be mentioned that the same maintenance that is available in STRSQL can be done through STRQM. However, a fundamental difference is that it can be restricted in QM where it's not in STRSQL.   Tom
    125,585 pointsBadges:
    report
  • jinteik
    only certain users can have strsql. imagine if your user owe the bank 1k and suddenly he strsql and he owe 0. so nope he should not have strsql. in my previous place, to use strsql, you need to have support documents and also approval from different parties before strsql can be used
    16,930 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