Kbase P13740: How to configure the SQL92 driver to access the database in
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/01/2003 |
|
Status: Unverified
GOAL:
How to set the SQL92 driver for Read Only
FACT(s) (Environment):
Progress 9.x
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
FIX:
There are two ways to only allow read access to the database via the ODBC driver.
1. Set the MERANT 3.60 32 bit Progress SQL92 v9.1x Default isolation level to Uncommitted Read.
A. This can be configured through the ODBC Datasource Administrator utility in the control panel.
B. Choose the MERANT 3.60 bit Progress SQL92 driver from the user DSN or the system DSN tab (which ever you have configured)
C. After highlighting click on configure, go to the Advanced tab and change the Default Isolation Level to Uncommitted Read.
This type of isolation level does not allow updates to the database.
2. Read only permissions can be set on a table by table bias.
This can be done by only granting the option to select on tables to the users in question. Below is a link to a solution that provides a sample procedure for granting permissions.
Solution 20419 Sample Procedure to Grant Privileges All Tables in a Schema