How to get user details Oracle Database

 Get users details in Oracle Database


set linesize 190

col username for a30

col password_version for a30

SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS; 



Comments