Wednesday, 13 January 2016

Retrieving passwords from user in oracle

select * from dba_users;

select DBMS_METADATA.GET_DDL('USER','SCOTT') from DUAL;

OUTPUT
------------
create user "SANDEEP"
IDENTIFIED BY VALUES 'S:E678BE8A02044521B5C8E4E9074A9ECAD807503963EBBAB7BE596334C57E;157E94BEA7ED4A10'
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"

No comments:

Post a Comment