Change Password

432
0
11-06-2010 11:30 PM
ThavitinaiduGulivindala
Occasional Contributor
Hi,

I have developed a command in Arccatalog to change the password for SDE Underlying Database, in my case it is Oracle. I have used IWorkspace.ExecuteSQL method to do the same using "ALTER USER ARCFM IDENTIFIED BY ARCFM123 REPLACE ARCFM" statement. I Could change the password succesfully but need to restart ArcCatalog for the new password to take effect if the Database is already connected after ArcCatalog is loaded. I mean, if the Database is connected with old password, change the password and could reconnect to the Database with old password.

How can achieve for the new password to take effect immediately.

Thanks in Advance.
0 Kudos
0 Replies