You should be able to assign individual permissions for users to tables using SQL Server Management Studio. When a User accesses this table via MIPro it will get the remote table's properties and respond accordingly by not allowing edits to be saved back to the server. MIPro is just going back & forth with ODBC in Windows via MIDLODBC.dll to deal with Table, Schema, and Database properties.
------------------------------
Bill Wemple
Principal Software Engineer, Quality Management
Precisely, Inc
precisely.com
------------------------------
Original Message:
Sent: 11-08-2021 10:34
From: Mark Dvorscak
Subject: sql server permissions
Can anyone tell me if it is possible to assign permissions to individual MapInfo tables stored in a MS SQL server database? What I would like to do is give read only access to certain tables and full access to others depending upon the the user's sign in via Windows Authentication. If you've implemented this, did it cause any problems with MapInfo? Almost all my users are on MapInfo 19 or 21 and we all use linked tables to access the database. I have 2 still on 15 but they will be upgraded early in 2022.
Thanks
------------------------------
Mark Dvorscak
LONE ROCK TIMBER CO
Roseburg OR
------------------------------