Thursday, May 29, 2014

Script to take user password backup in Oracle 11g

Script to take user password backup in Oracle 11g

Script to take user password backup in Oracle 11g

$ sqlplus "/as sysdba"

set pages 50000 lines 32767

select 'alter user ' || name || ' identified by values "' || password || "';' from sys.user$
where name in ('&name');

USER DDL

SET LONG 99999999
select dbms_metadata.get_ddl('USER','&username') from dual;

No comments:

Post a Comment