Re: security question: authority to build a logical

Rick,

If you're concerned about the size of the files, why not copy a small subset
of the data in the component PF's to a separate library and build your join
logical there?

That is what I do in these situations to save both space and time.

Steve

----- Original Message -----
From: <rick.baird@xxxxxxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Monday, October 20, 2003 1:16 PM
Subject: security question: authority to build a logical


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