Shulou(Shulou.com)06/01 Report--

# switch to Oracle user

Su-oracle

# Log in to sqlplus

Sqlplus / as sysdba

# set display format

Set pagesize 300

Set linesize 300

# query user list and user status

Select USERNAME,password,ACCOUNT_STATUS from dba_users

# View permissions assigned by users

Select * from dba_role_privs order by GRANTEE

Select * from dba_role_privs where GRANTEE = 'PATROL'

# query the password policy configuration of Oracle

Select profile from dba_users where username='user_name'

# query whether the default account uses the default password

[oracle@yjbsdb3 ~] $sqlplus

Set pagesize 300

Set linesize 300

Select USERNAME,password,ACCOUNT_STATUS from dba_users

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.