OraFAQ Forum: Server Utilities » password in oracle

Home » RDBMS Server » Server Utilities » password in oracle

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

password in oracle [message #73837]

Wed, 21 July 2004 21:51

premesh
Messages: 2
Registered: July 2004

Junior Member

hi
can i change the password which will be effective after 15 days means change password for the future.

Report message to a moderator

Re: password in oracle [message #73840 is a reply to message #73837]

Thu, 22 July 2004 03:48

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

a simple solution that just came on top of my head,
-- write your sql
alter user x identified by y;
-- shedule this to be run after 15 days
-- you can use dbms_job or any OS scheduler.

Report message to a moderator

Re: password in oracle [message #73842 is a reply to message #73837]

Thu, 22 July 2004 12:04

shoblock
Messages: 325
Registered: April 2004

Senior Member

CREATE PROFILE app_user LIMIT password_life_time 15;

alter user SOMEUSERNAME profile app_user;

Report message to a moderator

Previous Topic:	Transfer oracle data to Excel
Next Topic:	Oracle Installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 07:47:51 CST 2024