Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting around Vantage 6.1 ODBC 'Select Only' Security Settings

Status
Not open for further replies.

focusbiz1

Technical User
Dec 15, 2010
1
US
I am trying to set up an ODBC connection to Vantage 6.1 that will allow updates to the database. The current security configuration allows for read-only (from "61ODBCsecurity.txt" privilege is set to GRANT SELECT (=read-only).

I've changed everything from GRANT SELECT to GRANT UPDATE but still am prevented from making any changes to the tables.

The ODBC driver is Merant 3.60 32bit Progress SQL92 v.9.1D and I've tried all the available isolation levels. I have no problem linking to and creating Select queries with the current configuration but any update attempts always give the same "permission denied" error.

Any help is much appreciated!

Todd Gilbert
GCM, Inc.
Vantage 6.1
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top