SageForum for UK versions of Sage 50- Help and support.

I have been using ODBC connections into Excel for a while now, and am now looking at working with a colleague on some of the reporting we do.

I have been playing around with user permissions in Sage to restrict their access to more sensitive data, but no matter what I try, it seems like access to many of the tables is available regardless.

I have set up a user that currently has no permissions, confirmed by logging in to Sage.

When I run an ODBC query in Excel using that account, several of the tables throw a 42000 error for insufficient permissions as expected, such as INVOICE, SALES_LEDGER etc.

A lot still seem to be accessible however. In particular, all the AUDIT tables can be accessed which contain all the things I was trying to restrict access to, such as transactions for salary payments.

Is this normal behaviour, or is there something odd going on with our setup?

Sage access rights used to be really mucked up, they did different things to what they claimed but that was 5+ years ago.

I suggest you try using odbc with the demo data and setup a user in that with restricted access, if you get the same results then it is a "feature" of Sage.

Thanks Bruce. I have tried with the demo data and got the same results.

I hadn't got round to updating from v29 but will do that soon on the off chance that it's been resolved, although not really expecting that to be the case!