DM8达梦数据库:sql查询当前登录用户相关信息
SELECT '当前日期时刻' 用户相关信息,CAST(DBA_USERS.NOWDATE AS VARCHAR) 用户相关参数值 FROM DBA_USERS WHERE DBA_USERS.USERNAME=(SELECT USER) UNION ALL
SELECT '当前登录用户',USER UNION ALL
SELECT '当前用户创建时间',CAST(DBA_USERS.CREATED AS VARCHAR) FROM DBA_USERS WHERE DBA_USERS.USERNAME=(SELECT USER) UNION ALL
SELECT '当前用户状态',ACCOUNT_STATUS FROM USER_USERS UNION ALL
SELECT '密码策略',VALUE FROM V$PARAMETER WHERE NAME='PWD_POLICY' UNION ALL
SELECT '密码有效期',CAST(EXPIRY_DATE AS VARCHAR) FROM DBA_USERS WHERE DBA_USERS.USERNAME=(SELECT USER) UNION ALL
SELECT '当前用户默认表空间',DBA_USERS.DEFAULT_TABLESPACE FROM DBA_USERS WHERE DBA_USERS.USERNAME=(SELECT USER) UNION ALL
SELECT '表空间所在路径',DBA_USERS.PROFILE FROM DBA_USERS WHERE DBA_USERS.USERNAME=(SELECT USER) UNION ALL
SELECT '被授予的角色+是否拥有转授权限',USER_ROLE_PRIVS.GRANTED_ROLE||'+'||USER_ROLE_PRIVS.ADMIN_OPTION FROM USER_ROLE_PRIVS
结果显示如图: