RE: Changing Password

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Mon, 31 Jul 2000 23:36:17 +0300
Message-Id: <10575.113412@fatcity.com>

For this, you need Alter User privilege.

	-----Original Message-----
	From:	Sultan [SMTP:ssyed_at_fine.co.ae]
	Sent:	Wednesday, July 19, 2000 3:40 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Re: Changing Password

	Hai Gurus,

	Yes,there is a way to change your password.
	Use this command.
	ALTER USER USERNAME(SYSTEM OR OTHERNAME) IDENTIFIED BY PASSWORD;

	I tell you another trick for changing this passwords
	Suppose You dont know the pariticular Users Password ,you want to go
inside
	the User ,
	What you should do

	1) Select username,Password from dba_users ;

	2)Note down the particular User (the one you want to access)
Password ,may
	be look like this '9FG90GAEWER' (Do not forget to notedown this

password)

        3)Then use ALTER USER USERNAME IDENTIFIED BY PASSWORD(new password)

        4) then connect user/newpassword

        4)Play with this Users data

	5)Before exit keep  the password as before
	ALTER USER USERNAME IDENTIFIED BY VALUES  '9FG90GAEWER'(the one you
noted
	before)


	Regards.
	Sul


	----- Original Message -----
	To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
	Sent: Wednesday, July 19, 2000 11:29 AM




	> Hi,

	> One of my customer has forgotten the password for sys and system

user.Is


	> there anyway of

	> changing the password.

	>

	> Ravindra

	> --

	> Author: B, Ravindra

	>   INET: Ravindra.B_at_compaq.com

	>

	> Fat City Network Services    -- (858) 538-5051  FAX: (858)

538-5051


	> San Diego, California        -- Public Internet access / Mailing

Lists


	>

--------------------------------------------------------------------


	> To REMOVE yourself from this mailing list, send an E-Mail message

	> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and

in


	> the message BODY, include a line containing: UNSUB ORACLE-L

	> (or the name of mailing list you want to be removed from).  You

may


	> also send the HELP command for other information (like

subscribing).


	>


	-- 
	Author: Sultan
	  INET: ssyed_at_fine.co.ae

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may

Received on Mon Jul 31 2000 - 15:36:17 CDT