Re: Single schema access

[Charles Wilt <charles.wilt@xxxxxxxxx>]

There's exit points you can use.

But if it were me, I'd look at one of the third party packages that
provided those exit point programs.

Charles

On Fri, Jan 15, 2016 at 9:03 AM, <rob@xxxxxxxxx> wrote:

> Is there some way to say that if an ODBC user connects to your system they
> are only allowed to query data from one particular schema (aka library)?
>
> Due to a mess with security let's forego the thought of changing each of
> the several hundred schemas to GRTOBJAUT ODBCUSER *EXCLUDE one at a time.
>
> Normally I'm a big fan of securing the data itself and not trying to patch
> each of the several dozen ways one can access that data.  This is kind of
> an audit thing.  I'd really rather not go down this tangent and would
> rather focus on how I can limit this user to one schema via ODBC.
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.