Select to view content in your preferred language

Is there any way to look up and change the life time for SDE_DBA_PASSWORD?

935
2
Jump to solution
06-01-2012 06:07 AM
JianChen
Regular Contributor
I'm not sure if ArcSDE command line can do that, any idea?
0 Kudos
1 Solution

Accepted Solutions
JonDeRose
Esri Contributor
Hi Jian -


Should this password need to be changed you would need to know the current password but would have the ability to modify the SDE_DBA_PASSWORD as:

sdeservice -o modify -r SDE_DBA_PASSWORD -p sde-v newpassword -d ORACLE,SID -i esri_sde 


Password timeout and the grace period would be controlled via the supporting RDBMS

- Jon

View solution in original post

0 Kudos
2 Replies
VinceAngelo
Esri Esteemed Contributor
I'm not aware of any database product that doesn't use one-way encryption
on passwords.  Expiration and change of passwords is outside the scope of
the ArcSDE API.

The only thing ArcSDE command-line will let you do is delete Windows services
that use a password which has been changed or lost.

- V
0 Kudos
JonDeRose
Esri Contributor
Hi Jian -


Should this password need to be changed you would need to know the current password but would have the ability to modify the SDE_DBA_PASSWORD as:

sdeservice -o modify -r SDE_DBA_PASSWORD -p sde-v newpassword -d ORACLE,SID -i esri_sde 


Password timeout and the grace period would be controlled via the supporting RDBMS

- Jon
0 Kudos