Re: Search for Data Query Analysis tools

I am certainly in favor of object level security. We have a  user
requirement
to be able to build their own queries. This customer is transitioning
towards
object security, but at the same time needs a good query tool, with features
way beyond
OS400 Query. They saw the query internal security as a way to avoid IS
constantly having
to build and maintain a multitude of access paths. We need to replace the
OS400 Query long before the object security is done.
jim

----- Original Message -----
From: <rob@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, April 04, 2003 1:03 PM
Subject: Re: Search for Data Query Analysis tools


> I am curious about a package with field level security versus using either
> the field level security available in a physical file with V5, or with the
> more traditional method of securing people out of the physical and only
> allowing access via the various views you've created.
>
> Does one have to redefine all data to the tool?
>
> Or does one set up all of the inquiries and just tell the user to run
> those queries?  If so, then what is the difference between, setting up
> Query/400 queries and locking them out of WRKQRY but not RUNQRY, and this
> (security wise)?
>
> Rob Berendt
> --
> "They that can give up essential liberty to obtain a little temporary
> safety deserve neither liberty nor safety."
> Benjamin Franklin
>
>
>
>
> "Jim Franz" <franz400@xxxxxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 04/04/2003 11:58 AM
> Please respond to Midrange Systems Technical Discussion
>
>         To:     <MIDRANGE-L@xxxxxxxxxxxx>
>         cc:
>         Fax to:
>         Subject:        Search for Data Query Analysis tools
>
>
> Looking for Recommendations:
> I have a customer in search of Database Query and Analysis tools, and
> specifically
> looking to provide some Field Level security controls. Several years ago
> I worked with Showcase, and they had some of this built in.
> Are there other tools available that are recommended?
> tia
> jim franz
>
> _______________________________________________
> 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.
>
>
> _______________________________________________
> 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.
>
>