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?
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
ODBC User Permissions
-
PhilSage50
- User
- Posts: 2
- Joined: 05 Dec 2024, 09:22
- Sage Version: v29 UK/Europe/Africa
-
brucedenney
- Site Admin
- Posts: 4658
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: ODBC User Permissions
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.
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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
PhilSage50
- User
- Posts: 2
- Joined: 05 Dec 2024, 09:22
- Sage Version: v29 UK/Europe/Africa
Re: ODBC User Permissions
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!
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!
Who is online
Users browsing this forum: Ahrefs [Bot] and 0 guests