Home » RDBMS Server » Security » Defining a Oracle User password to never expire (ORACLE 6i)
icon4.gif  Defining a Oracle User password to never expire [message #391517] Thu, 12 March 2009 07:36 Go to next message
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
Re: Defining a Oracle User password to never expire [message #391524 is a reply to message #391517] Thu, 12 March 2009 07:46 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


by default it's never expire.

You can check using DBA_PROFILES
Re: Defining a Oracle User password to never expire [message #391529 is a reply to message #391517] Thu, 12 March 2009 07:53 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CREATE PROFILE

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


Current Time: Thu Mar 28 21:07:31 CDT 2024