From oracle-l-bounce@freelists.org Tue Mar 22 06:43:26 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2MCh46H028068 for ; Tue, 22 Mar 2005 06:43:14 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j2MCh4em028060 for ; Tue, 22 Mar 2005 06:43:04 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5B30A8861D; Tue, 22 Mar 2005 06:41:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07029-08; Tue, 22 Mar 2005 06:41:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E031388387; Tue, 22 Mar 2005 06:41:15 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=RkAfk7+4bN4XoVcAr2eBOI5EbY/FMitfoi7Ahz/Fe3yk8LpXc2wm3eKYaoxJi5979l5EKCaa42rZQe96A8qSdozyrzpeSMIsI2VK0uHH+NQT6FCGTuhM/vi9216jlHa+TROGcvDdd2xNyaYgwFLJP073RJFT5pZlh2CtkhXIcVc= Message-ID: <9177895d05032203381b87db13@mail.gmail.com> Date: Tue, 22 Mar 2005 06:38:43 -0500 From: rjamya To: "DGoulet@vicr.com" , oracle-l@freelists.org Subject: Re: Password generator In-Reply-To: <17ECCBDCF27C544583F2CAD928F953260221FB7B@memex1.corp.cefs.int> Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit References: <17ECCBDCF27C544583F2CAD928F953260221FB7B@memex1.corp.cefs.int> X-archive-position: 17570 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjamya@gmail.com Precedence: normal Reply-To: rjamya@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Dick, this is what we use ... you can change to suit your needs. BTW unless enclosed in double-quotes, oracle passwords are case-insensitive, so capital letters is a moot point IMO. PROCEDURE Generate ( USERID VARCHAR2 ) IS newpass varchar2(20); dbname varchar2(10); BEGIN dbms_output.enable(100000); newpass := dbms_random.string('U',4)||TO_CHAR(SYSDATE,'SS')||DBMS_RANDOM.STRING('U',2); execute immediate 'alter user '||USERID||' identified by '||newpass; select name into dbname from v$database; dbms_output.put_line('The new password for '||USERID||' is '||newpass||' in the '||dbname||' database.'); execute immediate 'alter user '||USERID||' password expire'; execute immediate 'alter user '||USERID||' account unlock'; EXCEPTION WHEN NO_DATA_FOUND THEN Null; WHEN OTHERS THEN -- Consider logging the error and then re-raise RAISE; END generate; / Raj -- http://www.freelists.org/webpage/oracle-l