creating a read only user for progress

[kblackwel]

I'm working on extracting data from a progress DB. I'm trying to avoid inadvertently writing over data. ( Using a data integration tool and would prefer to not fat finger or cause data to be written over)

I know permissions are set in the sysdbauth table, but which need to be set for read only access?

Thanks in advance.

 

[tamhas]

Are you talking SQL or ABL?

Did you read about the -RO parameter?

 

[kblackwel]

SQL.

I'm basically connecting odbc via the jar files. (openedge.jar)

Where would I apply the -RO flag? In the program I'm using, I might be able to adjust the connection string if that's where that flag is implemented.

Thanks.

 

[tamhas]

-RO is for ABL sessions.

You should be able to define the connection type as read-only in the ODBC definition. You might ask on the SQL forum for details.