How to Determine if user can Write from Excel

[GPC]

Hi All,

I have a situation where I want to be able to determine whether a user has Read or Write access to a particular TM1 cell from an Excel workbook.
i.e. there is a dbrw and the user may have Read or Write access to the TM1 cell depending on the current security. I could dbrw to the the security cube but the user could be a member of more than 1 group so this won't work. Is there any way to determine what their access is from Excel or VBA?

thanks,

Gregory

[Steve Vincent]

afraid not, you have to be an admin user to get that functionality

[TJMurphy]

A bit of a left-field approach but I was wondering if you could use VBA to store the current value, send a new value in, check if it's changed (proving write access) and sending the old value back in again to leave things "as they were".

The old auditor training in me though is cringing at the thought of doing it this way though

Do you get an error message if you run a DBS command in VBA that fails (due to lack of write-access)? Maybe that would trigger even if you sent the existing value in which might get past the control risk.

Tony

[David Usherwood]

If you were using a cell security cube (you may not be), you could make the cube available to TM1 readonly, iterate through the groups the user is in (using }ClientGroups) and get the access rights. Not exactly neat though.