MenuSuite & Users, How to Audit?

bhalpin

Hi.

For security documentation, a client requires a listing of the MenuSuite items and the users that can access each item. I've hunted, but this data seems to be well hidden in the database.

Does anyone know how/where to get this information? Maybe if I snooped around with ODBC?

Thanks in advance.

ara3n

Explain to the client that it is irrelevant. A user having access to Item card can click through all the way to the Chart of account
They need to look at security and see what every use has access to what table.

bhalpin

Thanks.

They know it's irrelevant. It's an outside auditing firm that is demanding the info - and unfortunately they won't take 'irrelevant' for an answer.

ara3n

the data is stored as blob in User Menu Level table. In order to see it. You have to manually go to edit mode. Right click on a menu and then select assign user. Then copy the list to excel.
Do this for each menu.

bhalpin

Thanks (again.)

Manually compiling the list is what they are trying to avoid - I am looking for an automated way to do it.

I looked at that table and it seems the "Object" blob is empty in all the records (Object.HASVALUE returns FALSE for all.)

:-k

ara3n

did you do a calcfields first?


As far as manual process. It takes 10 minutes to do it. I don't know how lazy can clients get.

bhalpin

did you do a calcfields first?

No - but with that in place there *is* data to export. The trouble is, it's pretty ugly binary stuff. Is there any 'roadmap' for it?

I don't know how lazy can clients get.

Lazy clients put food on my table. Ya gotta love 'em!

themave

ara3n wrote:

the data is stored as blob in User Menu Level table. In order to see it. You have to manually go to edit mode. Right click on a menu and then select assign user. Then copy the list to excel.
Do this for each menu.

I am end user, got the same request, I did this, but even a little simpler. I used as screen capture program, and just took a picture of the menu rather then cut and pasted into excel, they were happy, they could put a check mark in the box, under menu restrictions in place

ara3n

:P

Tell the client to tell the outside auditors that this feature is hidden from user for security reasons.
In order to see it, they have to call you and you will provide the data in excel.

bhalpin

Perfect !!! =D>

ara3n

I hope the client is not reading this.