Hello everybody,

how can I configure a odbc connection to read only access. On the windows xp machine the db2 adminstration is installed.

Is a keyword existing for the configuration?

Thanks toette

no not possible
just have this user granted select authority on needed tables and this will give read authority

This is not done at the connection level; grant the user in question only SELECT privileges and revoke INSERT, UPDATE, and DELETE privileges. This is assuming that the user does not have implicit authorities such as DBADM or SYSADM, which override individual object grants.