Listing Object Security by Group then security type

OneWorld 7.332 SP 11.1 SQL 7.0 NT

Does anyone know of a report to list all object security by user group and
security type (application, exit, tab, etc..)?
The reports under SECURITY only deal with actual security changes to user
id's and groups.


Example:

FINUSER P0011 3
FINUSER P0012 3
FINUSER P0012 1


Thanks,

Crawford Winter
Transamerica Life Canada

We wrote our own report to detailed security information.

Joy

We had to create our own for B7322. They're simple columnar reports that look at the security table.

OneWorld 7.332 SP 11.1 SQL 7.0 NT

Does anyone know of a report to list all object security by user group and
security type (application, exit, tab, etc..)?
The reports under SECURITY only deal with actual security changes to user
id's and groups.


Example:

FINUSER P0011 3
FINUSER P0012 3
FINUSER P0012 1


Thanks,

Crawford Winter
Transamerica Life Canada




--------------------------


C Ho

Intermediate Programmer/Analyst
B7322 SP 12.4
AS/400 coexistant with SQL Server 7.0
Sandbox: installing Xe

I just cut and paste to Excel or Access. It's not pretty but it works.

Colin




Colin Dawes, MSc
City of Guelph
B7332 SP13.1, Oracle 8.1.6, NT 4.0, Fat & WTS