OraFAQ Forum: Security » Defining a Oracle User password to never expire

Home » RDBMS Server » Security » Defining a Oracle User password to never expire (ORACLE 6i)

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

Defining a Oracle User password to never expire [message #391517]

Thu, 12 March 2009 07:36

akpasha
Messages: 1
Registered: March 2009
Location: Pakistan

Junior Member

i am using oracle 9i and i have an DB user "Ahmed" i would like; that its password never expires
how can i do so?
please advice

Regards,
Ahmed Kamal Pasha

Report message to a moderator

Re: Defining a Oracle User password to never expire [message #391524 is a reply to message #391517]

Thu, 12 March 2009 07:46

babuknb
Messages: 1734
Registered: December 2005
Location: NJ

Senior Member

by default it's never expire.

You can check using DBA_PROFILES

Report message to a moderator

Re: Defining a Oracle User password to never expire [message #391529 is a reply to message #391517]

Thu, 12 March 2009 07:53

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

CREATE PROFILE

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-01720: grant option does not exist for 'SYS.DUAL'
Next Topic:	Grant Unlock User

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 00:18:47 CDT 2023