Home » RDBMS Server » Security » Create user with non expiring password (Oracle 11.1.0.7.0, Unix-HP)
Create user with non expiring password [message #515004] Thu, 07 July 2011 12:22 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi ,

I want to create oracle user with non expiring password or
i want to create one oracle user and set the password as non expiring.

can somebody tell me how to do that ?


Thanks
Re: Create user with non expiring password [message #515005 is a reply to message #515004] Thu, 07 July 2011 12:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>can somebody tell me how to do that ?

CREATE USER .....

ALTER USER ...

please Read The Fine Manual!
Re: Create user with non expiring password [message #515021 is a reply to message #515004] Thu, 07 July 2011 14:23 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Every user has a profile, query dba_users to find which. In 11g, the default profile includes a password expiration. So either you need to create a new profile with no password expiry and assign it to your user, or you need to adjust the default profile to remove the expiry. Read up on profiles, and all will become clear.
Re: Create user with non expiring password [message #515029 is a reply to message #515021] Thu, 07 July 2011 14:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Read up on profiles, and all will become clear.


Laughing Did you see to whom you send this?

Regards
Michel
Re: Create user with non expiring password [message #515148 is a reply to message #515029] Fri, 08 July 2011 04:53 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Thank you John for your explanation..

I see a resource name PASSWORD_LOCK_TIME set to a limit of .0034.

PASSWORD_LOCK_TIME
==================
Specify the number of days an account will be locked after the specified number of consecutive failed login attempts.

what does .0034 means here ?

Can somebody explain it ?

Thanks

[Updated on: Fri, 08 July 2011 04:58]

Report message to a moderator

Re: Create user with non expiring password [message #515153 is a reply to message #515148] Fri, 08 July 2011 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is in day unit, so is the value in minutes?

Regards
Michel
Re: Create user with non expiring password [message #515162 is a reply to message #515153] Fri, 08 July 2011 05:42 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
But, PASSWORD_LOCK_TIME is not related to password expiry.

It says that, if a user fails to login (for example) 3 consecutive times, his/her account will be locked for ~5 minutes.
Re: Create user with non expiring password [message #515172 is a reply to message #515153] Fri, 08 July 2011 06:12 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Thank you Michel...

I am gonna set PASSWORD_LIFE_TIME to UNLIMITED for non expiring password for a user.

I will set this resource name PASSWORD_LIFE_TIME in a profile called 'test_profile' and assign it to a user 'BALA'.
So user BALA has no limit been set for the parameter i.e non expiring password.
This is what i needed.

I have one question to clarify here.If i want to set this resource
PASSWORD_LIFE_TIME to UNLIMITED for non expiring password for a user , do i need to change any other resources like '
PASSWORD_REUSE_TIME,PASSWORD_REUSE_MAX to UNLIMITED ?

steps to create profile and assign it to user.
==========================================

CREATE PROFILE test_profile LIMIT
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_LOCK_TIME UNLIMITED;

ALTER USER BALA PROFILE test_profile;

Please clarify my doubts

Thanks

[Updated on: Fri, 08 July 2011 06:14]

Report message to a moderator

Re: Create user with non expiring password [message #515175 is a reply to message #515172] Fri, 08 July 2011 06:23 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Littlefoot

Quote:
I see a resource name PASSWORD_LOCK_TIME set to a limit of .0034.


I just want to clarify the doubts that PASSWORD_LOCK_TIME is set to.

[Updated on: Fri, 08 July 2011 07:36]

Report message to a moderator

Re: Create user with non expiring password [message #515184 is a reply to message #515172] Fri, 08 July 2011 07:38 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
do i need to change any other resources like '
PASSWORD_REUSE_TIME,PASSWORD_REUSE_MAX to UNLIMITED ?

Did you read the definition of these parameters?
Are they related to what you want to limit or not?

Regards
Michel

[Updated on: Fri, 08 July 2011 07:40]

Report message to a moderator

Previous Topic: To Find A List Of Roles and Privileges In Database
Next Topic: Grant privs to public user
Goto Forum:
  


Current Time: Fri Mar 29 01:40:29 CDT 2024