Re: Object Security Problem

Ah... nevermind... it was a joined logical file. We didn't give access to
the other file in the join.
-- 
Mike Wills
Midrange Programmer/Analyst
http://whois.mikewills.name/
http://www.linkedin.com/in/mikewills


On Wed, Dec 17, 2008 at 9:38 AM, John Earl <john.earl-Ua2wos9bJ7y1Z/[email protected]> wrote:

>
> 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.
>
>
_______________________________________________
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.