Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Password Expire
- Thread starter devendrap
- Start date
RogerCruse
MIS
Hi,
I believe the password expiry is set gloablly. That is to say, if your installation has set an expiration for passwords of 90 days, then that's it.
I suppose you could setup a bit of code to log in and re-set it every 88 days, but why bother?
Roger...
I believe the password expiry is set gloablly. That is to say, if your installation has set an expiration for passwords of 90 days, then that's it.
I suppose you could setup a bit of code to log in and re-set it every 88 days, but why bother?
Roger...
- Thread starter
- #3
i assume u have dba access and Teradata V4+. you can
select expirepassword from dbc.securitydefaults
to see in how many days passwords expire. you can update it to anything you want. if you set it to 0 passwords will never expire. i believe you need to restart the database after you change the field. to change a user's password you can
modify user USERNAME as password=NEWPASSWORD for user
this is from volume 4 of the sql manual
select expirepassword from dbc.securitydefaults
to see in how many days passwords expire. you can update it to anything you want. if you set it to 0 passwords will never expire. i believe you need to restart the database after you change the field. to change a user's password you can
modify user USERNAME as password=NEWPASSWORD for user
this is from volume 4 of the sql manual
- Status
Similar threads
