Re: security question: authority to build a logical

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Rick, you might be able to make test files by using SQL to extract a few 
hundred records from the primary, then use SQL to get matching records, 
based on the join criteria. Of course, the optimizer makes different 
choices based on file size.

HTH

Vern

At 01:16 PM 10/20/2003 -0500, you wrote:
> Is there a way to grant authority to build logical files without granting
> data authority (add, change, delete, clear, etc.)
>
> not on a file by file basis - preferably globally via user profile
> authorities, or, in a pinch, by library.
>
> The reason is, (as you may guess based on my last post), I'm trying to
> improve performance by building logical files suggested by the query
> optimiser.   I don't have a proper testing environment, and the files are
> too big to make copies of just for a quick logical build and test.
>
> thanks,
>
> rick