نسيت باسوور يوزر ويعمل عليه برنامج

ولا اريد تغيير الباسوورد

connect with 

as sysdba/

تم تعديل 10 يونيو 201510 سنة بواسطة OsamaArmosh92

like this

السلام عليكم توجد طريقة مثل العملية الجراحية بحيث تقدر تسترجع الباسورد المشفر وتغيره ومن ثم ترجعه مرة اخرى

اليك المثال

 

 

ORCLDBA@DAVIDLAB> create user mytest identified by f1rstp3ssword;
 
User created.
 
Elapsed: 00:00:00.10
ORCLDBA@DAVIDLAB> grant connect to mytest;
 
Grant succeeded.
 
Elapsed: 00:00:00.03
ORCLDBA@DAVIDLAB> show user
USER is "ORCLDBA"
ORCLDBA@DAVIDLAB> conn mytest/f1rstp3ssword@DAVIDLAB
Connected.
 
MYTEST@DAVIDLAB> show user;
USER is "MYTEST"
MYTEST@DAVIDLAB> conn ORCLDBA@DAVIDLAB
Enter password:
Connected.
 
ORCLDBA@DAVIDLAB> show user
USER is "ORCLDBA"
ORCLDBA@DAVIDLAB> select 'alter user '||username||' identified by values '||REGEXP_SUBSTR(DBMS_METADATA.get_ddl ('USER',USERNAME), '''[^'']+''')||';'
  2  from dba_users
  3  where username = 'MYTEST';
 
'ALTERUSER'||USERNAME||'IDENTIFIEDBYVALUES'||REGEXP_SUBSTR(DBMS_METADATA.GET_DDL('USER',USERNAME),'''[^'']+''')||';'
------------------------------------------------------------------------------------------------------------------------
 
alter user MYTEST identified by values 'S:A4CE024B548C4C11C886A735F0D00314C1050C7A9C4FC492585BA2BC8520;D9402F621C938AC1';
 
Elapsed: 00:00:00.39
ORCLDBA@DAVIDLAB> alter user mytest identified by someth1ngdiffer3nt;
 
User altered.
 
Elapsed: 00:00:00.06
ORCLDBA@DAVIDLAB> conn mytest/someth1ngdiffer3nt@DAVIDLAB
Connected.
 
MYTEST@DAVIDLAB> show user
USER is "MYTEST"
MYTEST@DAVIDLAB> conn ORCLDBA@DAVIDLAB
Enter password:
Connected.
 
ORCLDBA@DAVIDLAB> show user
USER is "ORCLDBA"
ORCLDBA@DAVIDLAB> alter user MYTEST identified by values 'S:A4CE024B548C4C11C886A735F0D00314C1050C7A9C4FC492585BA2BC8520;D9402F621C938AC1';
 
User altered.
 
Elapsed: 00:00:00.09
ORCLDBA@DAVIDLAB> conn mytest/f1rstp3ssword@DAVIDLAB
Connected.
 
MYTEST@DAVIDLAB> show user
USER is "MYTEST"
MYTEST@DAVIDLAB>

 

ماشا الله حل مفيد .. ومخيف بنفس الووووووووووووووقت...

 

مالك حل يا مبدع.. ماشا الله عليك..