Alooo..
Permisi, mau nambahin sedikit mungkin berguna. Untuk mengubah password user
dengan syarat DBA tidak boleh tau password user tersebut sama sekali dengan
alasan Security.
Berikut contohnya :
H:\>sqlplus [EMAIL PROTECTED]
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 9 10:01:27 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> password
Changing password for ANDREW
Old password:
New password:
Retype new password:
Password changed
SQL>
cheers,
Andrew
--- In indo-oracle@ yahoogroups. com, "Rudy Gunawan" <rudygunawan@ ...>
wrote:
>
> Halo teman2,
>
> Saya pemakai baru oracle 9i
> Rencana nya saya mau ubah password salah satu user di sqlplus.
> Gmn ya caranya?
> Terus kalo user tsb sudah kita kasih grant, apakah dgn diubah
password nya, grantnya akan hilang (kita mesti grant kembali)?
>
> Trims,
> Rudy
>
>
> [Non-text portions of this message have been removed]
>
New Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/sg/
[Non-text portions of this message have been removed]
