Kbase P19088: How to define a Progress SQL-89 ODBC connection as read-only
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/27/2010 |
|
Status: Verified
GOAL:
How to define a Progress SQL-89 ODBC connection as read-only
GOAL:
How can I make a Progress SQL-89 ODBC connection read-only?
GOAL:
Using the -RO parameter to make a Progress SQL-89 ODBC connection read-only
FACT(s) (Environment):
Progress 8.x
Progress 9.x
UNIX
Windows
MERANT 3.50 32-BIT Progress SQL-89
MERANT 3.60 32-BIT Progress SQL-89
MERANT 3.70 32-BIT Progress SQL-89
MERANT 4.0 32-BIT Progress SQL-89
FIX:
A SQL-89 ODBC connection can be defined as Read Only by:
1. Set the Default Isolation Level on the Advanced tab of the SQL-89 ODBC DSN to SQL_TXN_READ_UNCOMMITTED
2. Set read only privileges on the server side for clients by defining users in the database and setting the required privileges for each user.