Oracle 用户状态查询

Oracle 用户状态查询#切换到Oracle用户su - oracle#登录sqlplussqlplus / as sysdba#设置显示格式set pagesize 300;set linesize 300;#查询用户列表及用户状态select USERNAME,password,ACCOUNT_STATUS from dba_users;#查看用户分配的权限select * from dba_role_privs order by GRANTEE;select * from dba_role_privs where GRANTEE = "PATROL";#查询Oracle的密码策略配置select profile from dba_users where username="user_name";#查询默认帐户是否使用默认口令[oracle@yjbsdb3 ~]$ sqlplusset pagesize 300;set linesize 300;select USERNAME,password,ACCOUNT_STATUS from dba_users;更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址