Is it possible to give a user access to sql screen wherein he is allowed only to use select commands

1160 pts.
Tags:
AS/400
iSeries
select command
sql command access
Is it possible to give a user access to sql screen wherein he is allowed only to use select commands. We have a team of users who use a set of 10 - 15 select commands on daily basis.

Software/Hardware used:
i750,iseries

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: 2  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
  • BigKat
    are they "fixed" commands (i.e. the same everytime) - create them in QMQRY queries, and add them to a menu for them. if they have to enter varying parameters (e.g. different customer numbers) you can do that as well.  You will just need to create a "wrapper" program to prompt for the parameters, and then call the query passing it those values.
    7,935 pointsBadges:
    report
  • TomLiotta
    QM queries seem to be the way to go, though there's no need to create QM queries for them. Just let them use the STRQM command and restrict them from using STRSQL. I don't recall a way to restrict statements in STRSQL. (There shouln't be a need to restrict statements. Users shouldn't have the authority to cause damage with SQL statements, so there shouldn't be a reason to limit statements.)   With QM, an administrator can choose the SQL statements that any user can run. Just set SELECT as the only allowed statement. You might also set the user's default mode to SQL, and also allow the user to switch to prompted mode if desired.   The user can then enter a SELECT statement, get practically the same statement prompting assistance as with STRSQL, and save queries if desired.   The big loss is the statement history. But if the history only contains a few different SELECT statements, users might choose just to save each one in their own QM query objects.   Tom
    125,585 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