Re: Private authority report

Bryan_Burns wrote:

I did that by searching for "in use" but would have to search 49 times. And I
only got a job log because I had time to request one while it the GRTOBJAUT was running.
Hate to think where I'd be without a joblog. I'd also hate to implement object level
security if it's so difficult to get such a list.

-----Original Message-----

Absent a Vendor provided security tool that will list the authorities of
objects in the library, you can review your joblog to see which items
were not changed.

Bryan:

Apologies for a late response; sometimes work needs attention.

Although numerous details may need to be added, you _might_ get by with:

1. DSPUSRPRF USRPRF(ODBCUSER) TYPE(*OBJAUT) OUTPUT(*OUTFILE)
2. DSPOBJD OBJ(AMFLIBE/*ALL) OBJTYPE(*FILE) OUTPUT(*OUTFILE)

Given those two files, a SELECT over the first file WHERE OALIB='AMFLIBE' AND NOT OAOBJ IN( SELECT ODOBNM FROM the 2nd file), should be about all there is to it.

All kinds of variations are possible.

Tom Liotta