try log on function, if that works
Means, Can you please elaborate this
sql> conn forbkp/forbkp
tried same in sql developer, got connected. I close/disconnect the user.
sql> alter user forbkp password expire; as sysdba i execute the cmd
sql> conn forbkp/forbkp
ORA 28001 : the password has expired.
will connect via sql developer, I get same ORA 28001
Hope it helps....
Thanks for your reply,
I also checked the above test which you mentioned. I want that when there is grace period sql developer prompt that your password is going to expired in n days.
This thing i checked from sqlplus and its working fine but from sql developer it's not appearing for grace period.
Instead of adapting each separate tool for a message that is not detailed in the first place already, maybe it can be interesting to let the monitoring/managing system contact users via a system that is not directly linked to the actual user login, and a system that at the same time allows for more information. I'm instantly thinking about mail.
I used to get 'password will expire in n days' when i used to login via sql developer.. may be its when 8-10 days are left out for password expiration.(not sure)
you might want to look into below link, might be helpful. (profile creation)
Still i am not clear what need to do.
Kindly help over the same
I created a profile with 'password_life_time 2' & assigned to schema.
then logedin via sqlplus & i dint get message 'password will expire'...same in sql developer.
but when i checked expiry_date from dba_users it showed 10-sep2014.
Need Seniors to step in here...
You don't get the expiry notice until after a password has actually expired.
The LOCK profile paramter tells you how many days you get AFTER it has expired to keep working before you're formally locked out.
SQL Developer should be showing the password expiry notice with no setup required.
The only thing that requires config is if you want the user to be able to reset their password w/o having to login - this requires a thick client be installed on the machine and SQL Developer setup to use it on the Preferences > Database > Advanced page.
need small clarification....
I am continuing with same scenario mentioned above ie; created profile with 'password_life_time 2'
conn / as sysdba connected
alter user test password expire; altered
now when i connect via sqlplus i am prompted to change my password
but when i connect to sql developer i get ORA 28001 password expired.
"You don't get the expiry notice until after a password has actually expired." --- did you mean that i should not use command to expire the password, instead should wait for the profile policy to get applied & only then I will get ORA 28002 error in sql developer?
Please clear my doubt...
I checked it by changing my system date.
yes it does get connected, will have 8 days of grace period(max) also gave warning in both sqlplus prompt & sql developer.
I hate to say this, but the only good feature of Toad is that, in response to a 28001, 28002 it will prompt you for a new password (like sqlplus does) and then allows you to proceed.
No need to contact the DBA, or use another tool to change your password....
You can totally change your own password with SQL Developer, w/o asking the DBA for help or using another tool.
You're just a right-click away.
Note, when you change your password via the UI, we also change the password that's stored in the connection settings to match - so don't be confused when your login works w/o you having to re-enter your password.