-- 查询达梦数据库用户密码加密值
-- 查询达梦数据库用户密码修改时间
SELECT U.NAME,U.ID,U.CRTDATE,VALID,P.OLD_PWD,P.NEW_PWD,MODIFIED_TIME
FROM SYS.SYSOBJECTS U
LEFT JOIN (SELECT * FROM SYS.VSYSPWDCHGS) P
ON U.ID=P.LOGINID
AND P.NEW_PWD NOT IN (SELECT OLD_PWD FROM SYS.VSYSPWDCHGS WHERE OLD_PWD IS NOT NULL AND OLD_PWD <>'')
WHERE U.SUBTYPE$ ='USER'
ORDER BY NEW_PWD DESC;
--查询数据库密码相同的用户
SELECT U.NAME,P.NEW_PWD
FROM SYS.SYSOBJECTS U
LEFT JOIN (SELECT * FROM SYS.VSYSPWDCHGS) P
ON U.ID=P.LOGINID
WHERE U.SUBTYPE$ ='USER'
AND P.NEW_PWD IN
(SELECT NEW_PWD FROM SYS.VSYSPWDCHGS
GROUP BY NEW_PWD HAVING COUNT(NEW_PWD)>1)
ORDER BY NEW_PWD DESC;
– 查询达梦数据库用户密码加密值
– 查询达梦数据库用户密码修改时间