ODBC Access security

Yahoo Archive
1
>
> Where can I find the ODBC kit?
>

Use your Epicweb login and go to:

ftp://ftpmpls.epicor.com/vantage/ODBC/

There you will find the ODBC kits for multiple versions of Vantage.

Mark W.
2
When you create an ODBC connection, the default user is sysprogress. To my knowledge this user has full access. Is there a way to create a user that has only read access to the database?

I'm afraid that if somebody changes the ODBC default isolation level to 'READ COMMITTED', they would be able to edit the database directly. Is there a way to limit the user ID from having edit access?

Thanks,
Jasper



[Non-text portions of this message have been removed]
3
> I'm afraid that if somebody changes the ODBC default isolation level to
> 'READ COMMITTED', they would be able to edit the database directly. Is
> there a way to limit the user ID from having edit access?

This is mentioned in the ODBC kit. We created a new ODBC user and granted
only read access to a limited number of tables. Works like a charm.

Mark W.
4
Where can I find the ODBC kit?

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Monday, July 21, 2008 12:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Access security


> I'm afraid that if somebody changes the ODBC default isolation level to
> 'READ COMMITTED', they would be able to edit the database directly. Is
> there a way to limit the user ID from having edit access?

This is mentioned in the ODBC kit. We created a new ODBC user and granted
only read access to a limited number of tables. Works like a charm.

Mark W.





[Non-text portions of this message have been removed]