Re: Object Security Problem
"John Earl" <john.earl-Ua2wos9bJ7y1Z/[email protected]> Wed, 17 Dec 2008 07:38:07 -0800
| Newsgroups | gmane.comp.systems.as400.security |
|---|---|
| Message-ID | <[email protected]> |
No, the Select statement does not require you to give the user any additional authority to the database. jte -- John Earl The PowerTech Group, Inc. Direct: 253-479-1408 Mobile: 206-669-3336 www.powertech.com > -----Original Message----- > From: security400-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > [mailto:security400-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Mike > Sent: Wednesday, December 17, 2008 7:13 AM > To: Security Administration on the AS400 / iSeries > Subject: [Security400] Object Security Problem > > We are creating a logical view of data for a user who needs > access to only data for their department. We are using an > exit program with a switch user to lock this person out of > the main table. Normally we give this switch user *READ > access to the physical file and *USE access to the logical. > This is the first logical with a select in it. Do they need > more access to the physical file for a select? If so, what do > they need? > > -- > Mike Wills > Midrange Programmer/Analyst > http://whois.mikewills.name/ > http://www.linkedin.com/in/mikewills > _______________________________________________ > This is the Security Administration on the AS400 / iSeries > (Security400) mailing list To post a message email: > Security400-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change > list options, > visit: http://lists.midrange.com/mailman/listinfo/security400 > or email: Security400-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, > please take a moment to review the archives at > http://archive.midrange.com/security400. > > > _______________________________________________ This is the Security Administration on the AS400 / iSeries (Security400) mailing list To post a message email: Security400-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/security400 or email: Security400-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/security400.