Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

Limit the interactive SQL for modifing data in the files

I'm an AS/400 system administrator
I want to let our programmers to use the Interactive SQL on the production AS/400 but I want that the only thing thay will be able to do it to select from a file and not to change the data in the files by insert, delete or update by SQL command.

1 Solution
theo kouwenhovenCommented:
Set the object authority of the objects to READ (for object and data).
If they are alowed to make changes with programs, you have to set the program to an other userprofile to *OWNER and change the object owner to a profile (or groupprofile) that hve the required authority.


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now