Link to home
Start Free TrialLog in
Avatar of taaz
taaz

asked on

setting up oracle user account to expire in xx months

I have oracle user account that need to be set such as that their password expire after 6months, 12months and 18months
win 03
version 9.2

thanks
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

ALTER PROFILE lets you modify a particular parameter.  The sample syntax is ALTER PROFILE xxx LIMIT PASSWORD_LIFETIME 180;
where xxx is the profile associated with the account(s) in question.
SOLUTION
Avatar of Guillaume Zussy
Guillaume Zussy
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
oups... Already answered, sorry. I began to write before you answered ;-)
Avatar of taaz
taaz

ASKER

If I assign a profile "pass_exp" to a user would it change his privileges that the user was having or it would remain the same except the one in the profile "pass_exp"?  
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of taaz

ASKER

basicall  I like to extend the user password expiration time without hurting all privileges the user is having  such that

userA1,userA2,userA3 passowrd expire after 180 days

user B1,userb2.userB3 password expire after 365days

userC1,userC2,userc3   password expire after 90 days

I just want to extend the password but want other privileges to remain the same.
dvz, tell me if i'm wrong but he can create a single profile with the limited password and others privileges stuff. Is that right ?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial