Security Report

[wwwedward]

Is there a report to show user and group security in macola? I seem to be lost on this issue? or an ICR report maybe?

 

[Guest_imported]

The Screens folder has it's own set of DDF's, so you can write Pervasive/Btrieve reports off the files in this folder - SYSPASS, SYSMENU etc. The SYSPASS gives a summary of the user access, the SYSMENU gives the actual menu options and details that each user has. The SYSMENU table has a 'child/parent' structure similar to the BMPRDSTR table so it's a PITA to write reports on...

Peter Shirley

http://www.linkcorp.com

 

[gmdcorp]

What if I wanted the see only the changes in user permissions? Would I need to write a script?

 

[keain]

You'll want to use Triggers. Something along this line:

AFTER INSERT
INSERT INTO syspass_AuditTrail SELECT 'syspass_sql' as TableName, 'Insert' as Action, USER() as ModifiedBy, NOW() as ModifiedDate FROM __new

AFTER DELETE
INSERT INTO AuditTrail SELECT 'syspass_sql' as TableName, 'Delete' as Action, USER() as ModifiedBy, NOW() as ModifiedDate FROM __new

 

[NEmacGuy]

In progression System Manger, Reports, Lists-2 user setup.
Else do a crystal report on the screens db SYSPASS table. If security is a big issue understand the passwords in that table are in plain text. Exact does not grant users access to any databases from outside of Macola, as such this is not an issue to them. If someone snoops and finds it, it was the fault of the person that gave rights to db.

 

[dgillz]

There is an existing report as NEMAcGuy states, however it doesn't work.

Having said that, they have a new report due out in Service Pack C (No idea on a release date yet) that is supposed to work. I have been waiting patiently.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[keain]

The report in 7.6.300 is a vast improvement over the old report, but like any report, bad, incomplete records in the syspass or syscomp tables will throw the report off.

 

[keain]

I don't see a way to edit posts, so, in my post directly above this one, it should read, 'The report in 7.6.300c...'

 

[dgillz]

Do you own event manager? If so I would create an email notification based on the change in value of the SYSPASS table. This should be very simple. In fact for kicks I am going to try this later today and I'll post back my findings.

If you don't have Event Manager take a look at it, you'll love it.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz