Using exit points to manage SQL requests
I am trying to determine if there are any specific exit programs I can use to limit user abilities within the interactive...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
SQL on the iSeries. I need to limit some users from being able to insert/update/delete database files while not shutting them out of SQL altogether. I was hoping there was a single exit point I could use. Unfortunately, there is no one exit point that will allow you to manage SQL requests. In addition, these exit programs are not trivial and can change from release to release. To determine what file is being accessed you must parse the incoming request statement. If you cannot manage user access via object authority to the files you want to protect, then I suggest you look into one an exit program software package available from many security software vendors. However, I encourage you to investigate placing object authorities on the files you wish to protect because those authorities will be there no matter what interface the file is being accessed through -- sockets, Web applications such as WebSphere, and command line access, etc in addition to all of the network interfaces such as FTP and ODBC.
==================================
MORE INFORMATION ON THIS TOPIC
==================================
The Best Web Links: tips, tutorials and more.
Search400's targeted search engine: Get relevant information on security.
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
Check out this Search400.com Featured Topic: Top ten security tips
Dig Deeper on iSeries system and application security
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our AS/400 experts
View all AS/400 questions and answers
Start the conversation
0 comments