Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / December 2005

Tip: Looking for answers? Try searching our database.

Help-Sybase to DB2 migration

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pankaj_wolfhunter@yahoo.co.in - 25 Dec 2005 11:31 GMT
Greetings,
               Sybase authentication is managed by the database
manager
whereas DB2 relies on OS userid and password.
when we migrate from sybase, there are certain applications that are
using userid and password stored in sybase system tables. of course
these are not OS based userid/password.

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?

Any help would be appreciated

TIA
Bernd Hohmann - 25 Dec 2005 12:51 GMT
> 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

Signature

"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

pankaj_wolfhunter@yahoo.co.in - 29 Dec 2005 12:48 GMT
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.