 |
|
茫茫網海中的冷日
發生過的事，不可能遺忘，只是想不起來而已！ |
|
|
恭喜您是本站第 1729867
位訪客!
登入 | 註冊
|
|
|
|
| 發表者 |
討論內容 |
冷日
(冷日) |
發表時間：2019/3/22 11:57 |
- Webmaster
- 註冊日: 2008/2/19
- 來自:
- 發表數: 15773
|
- [轉貼]How to retrieve oracle passwords
- How to retrieve oracle passwords
Oracle Database Tips by Donald Burleson
Question:
I need to sign-on as an end-user for troubleshooting, but they don't want their password changed. Can I save their existing password, do my work, and put back their old password?
Answer:
You can retrieve an existing password as an encrypted value and you can also copy encrypted passwords between databases.
The dbms_metadata procedure allows you to copy user accounts from one instance to another with the same password, grants, roles, etc, without using the exp/imp tools.
You wont be able to see the password (sorry hackers), but you can copy it in its encoded form. This is extremely useful for DBAs that are copying their production database to development, or migrating a database from one instance to another.
Here we use the DBMS_METADATA package to pull the user password information. Once the encrypted password is captured, it can be re-inserted into the user ID after you are done testing:
select
dbms_metadata.get_ddl('USER', username) || '/' usercreate
from
dba_users;
USERCREATE
--------------------------------------------------------------
CREATE USER "SYS" IDENTIFIED BY VALUES 'F894844C34402B67'
DEFAULT TABLESPACE "SYSTEM" TEMPORARY TABLESPACE "TEMP"/
原文出處：How to retrieve oracle passwords
|
|
|
討論串
|
[轉貼]how to unlock user (冷日