Re: Read only special authority?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

If *PUBLIC has anything but *USE or *EXCLUDE on the objects
now...you've got much larger problems...

Ideally, *PUBLIC should be *EXCLUDE...in which case you should
hopefully have at least a few *AUTL securing your objects and all
ready have a "read only" group profile with authority to the
*AUTL....so just add the user to the group profile.

If you don't, why not take the time to do it right instead of
continuing to take the time to do it wrong?

Charles

On Tue, Nov 30, 2010 at 12:28 PM, Josh Diggs <JDiggs@xxxxxxxxxxxx> wrote:
> I have created a user to be used by a report application that connects via JDBC.  What I am looking for is an efficient way to grant this user read only access to large groups of files in our ERP data libraries without having to grant authority on each individual file.  I was hoping to find a solution similar to giving the user *allobj special authority that would allow read only access.
>
> Any thoughts or suggestions?
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.