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;
$ 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