Home » RDBMS Server » Security » Change Password
Change Password [message #21410] Thu, 01 August 2002 12:37 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
Hello ,

Can someone help with me with this.

I need to change the passwords of my Oracle production and development databases. What would be the syntax for it ? Are there any things that I've to make sure before or after chaging it.

Your help on this ASAP would be highly appreciated.

Thanks!
Alpesh
Re: Change Password [message #21411 is a reply to message #21410] Thu, 01 August 2002 13:06 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
-- from SCOTT
alter user SCOTT identified by TIGER;

Make sure that incoming database links have their passwords changed if they have passwords explicitly specified (not all Db links do). Obviously consider all scrips, Web applications and other apps which connect to the user too.
Previous Topic: Security and Stored procedures/anonymous PL/SQL blocks
Next Topic: permission when accessing object in PL/SQL granted by role
Goto Forum:
  


Current Time: Sat Apr 20 10:08:50 CDT 2024