Password Policy [message #435168] |
Mon, 14 December 2009 19:02  |
|
2 questions:
a) Anyway to set password policy in Oracle 10g? Such as expire in 6 mths.
b) Any tool for client to change password in windows environment?
Thanks
|
|
|
Re: Password Policy [message #435171 is a reply to message #435168] |
Mon, 14 December 2009 22:58   |
 |
ramoradba
Messages: 2456 Registered: January 2009 Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
1)
http://youngcow.net/doc/oracle10g/server.102/b14200/statements_6010.htm
2) all depends on your Application logic.Hold on...Please let me know this first.
What do you mean by "client" here?your product clients?Or the users in your database?
SQL> conn sriram/sriram
Connected.
SQL> password
Changing password for SRIRAM
Old password:
New password:
Retype new password:
Password changed
SQL> conn sriram/sriram
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> conn sriram/tejajun20
Connected.
SQL>
Sriram.
[Updated on: Mon, 14 December 2009 23:03] Report message to a moderator
|
|
|
Re: Password Policy [message #435177 is a reply to message #435171] |
Tue, 15 December 2009 00:11   |
|
Actually my company is using ERP system but unfortunately the system doesn't provide a place for changing password. Thus the client is referring to application client.
Thanks
|
|
|
|
|
|
Re: Password Policy [message #435386 is a reply to message #435383] |
Wed, 16 December 2009 00:06   |
|
1/ The oracle client was installed in their workstation(without sql plus)
3/ Can I update the system table (sys.user$) using sql command as I havent tested before.
|
|
|
|
Re: Password Policy [message #435406 is a reply to message #435387] |
Wed, 16 December 2009 02:51   |
|
Thanks, i have found change password command in VB:
With using the OracleInProcServer reference:
Dim oo4oSession As OraSession
Set oo4oSession = New OraSessionClass
oo4oSession.ChangePassword DSN, oldpwd, newpwd
|
|
|
|