OraFAQ Forum: Security » Create user with non expiring password

Home » RDBMS Server » Security » Create user with non expiring password (Oracle 11.1.0.7.0, Unix-HP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create user with non expiring password [message #515004]

Thu, 07 July 2011 12:22

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

Report message to a moderator

Re: Create user with non expiring password [message #515005 is a reply to message #515004]

Thu, 07 July 2011 12:25

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!

Report message to a moderator

Re: Create user with non expiring password [message #515021 is a reply to message #515004]

Thu, 07 July 2011 14:23

John Watson
Messages: 8960
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.

Report message to a moderator

Re: Create user with non expiring password [message #515029 is a reply to message #515021]

Thu, 07 July 2011 14:37

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Read up on profiles, and all will become clear.

Did you see to whom you send this?

Regards
Michel

Report message to a moderator

Re: Create user with non expiring password [message #515148 is a reply to message #515029]

Fri, 08 July 2011 04:53

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is in day unit, so is the value in minutes?

Regards
Michel

Report message to a moderator

Re: Create user with non expiring password [message #515162 is a reply to message #515153]

Fri, 08 July 2011 05:42

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Create user with non expiring password [message #515172 is a reply to message #515153]

Fri, 08 July 2011 06:12

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

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 21:01:37 CST 2024