對這文章發表回應
發表限制: 非會員 可以發表
發表者: 冷日 發表時間: 2019/3/22 11:57:31
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:
原文出處: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