11-22-2009 01:27 PM - edited 02-21-2020 03:48 AM
Hello !
We are using UnixODBC and FreeTDS to connect to the LMS 3.2. We use the utility isql
We have enabled the username lmsdatafeed and the pw. We have created a dsn in the odbc.ini to connect to RME.
We manage to connect to the database ( rmengdb) but when trying to do a select on a table we get a deny permission.
isql -v CW2Ktrace lmsdatafeed xxxx
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
select Device_ID from NETWORK_DEVICES
[42501][unixODBC][FreeTDS][SQL Server]SQL Anywhere Error -121: Permission denied: you do not have permission to use the "CREATE PROCEDURE" statement
[ISQL]ERROR: Could not SQLExecute
Is there something that we have bypassed ?
The same user ID and the password work when we access in a windows through ODBC, and Microsoft Access the RME database.
Thanks for your help,
11-22-2009 03:55 PM
What is CW2Ktrace? The first argument to isql should be the dsn (cmf in this case). It also looks like unixODBC or FreeTDS may be sending additional query data to the database server. The user used for direct database access only has read-only access, so creating anything will not be possible. Certainly, a SELECT query should not be creating a stored procedure, so that makes me think unixODBC or FreeTDS is doing something behind the scenes.
You may want to check with their support mailing lists to see if they do any kind of hidden queries like this.
11-23-2009 04:09 AM
Hello,
CW2Ktrace is the dsn defined in odbc.ini with the parameters to connect to rmengdb, so host, port, driver, tds version(5), etc..
After setting up a trace, I can confirm that yes, isql sends a "create procedure". This is what we see in the trace:
create proc ik80336000 as select PROCESSOR_MEMORY from MEMORY_INVENTORY
We have addressed this to unixodbc
Thanks
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide