Oracle user status query

Oracle user status query

Oracle user status query

# Switch to an Oracle user

Su-oracle

# Log on to sqlplus

Sqlplus/as sysdba

# Set the display format

Set pagesize 300;

Set linesize 300;

# Querying the user list and user status

Select USERNAME, password, ACCOUNT_STATUS from dba_users;

# View User-assigned Permissions

Select * from dba_role_privs order by GRANTEE;

Select * from dba_role_privs where GRANTEE = 'patterl ';

# Querying Oracle password policy configuration

Select profile from dba_users where username = 'user _ name ';

# Querying 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;