View Single Post

   
  #2 (permalink)  
Old 02-27-2008, 05:41 AM
Bernd Hohmann
 
Posts: n/a
Default Re: Help-Sybase to DB2 migration

pankaj_wolfhunter@yahoo.co.in wrote:

> now when we migrate to DB2 it checks for these userid/passwords as OS
> related. but these are stored in Sybase system tables.
> how should we overcome this problem when we migrate to DB2.
> do we have to remove the user/password out of the code?


The easiest way is to create all users in the operating system and read
the users with the user privileges from the DB2 system tables.

For JDBC sessions its enough to create one user for DB2 and manage the
application users by yourself.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe
des 18. März in Berlin
Reply With Quote