Oracle Management Security and Resources (i) Oracle policy files

Profile is a named collection of password limits and resource constraints. When an Oracle database is established, Oracle automatically creates a default profile and then assigns each user, and if not specified, the user will enable default profile.

1. View Password file

09:07:15 sql> Select Username, profile from dba_users;

USERNAME profile

------------------------------ ------------------------------

Mgmt_view DEFAULT

SYS DEFAULT

SYSTEM DEFAULT

Dbsnmp Monitoring_profile

Sysman DEFAULT

SCOTT DEFAULT

Outln DEFAULT

Mdsys DEFAULT

Ordsys DEFAULT

Exfsys DEFAULT

Dmsys DEFAULT

Wmsys DEFAULT

Ctxsys DEFAULT

ANONYMOUS DEFAULT

XDB DEFAULT

Ordplugins DEFAULT

Si_informtn_schema DEFAULT

USERNAME profile

------------------------------ ------------------------------

Olapsys DEFAULT

Tsmsys DEFAULT

BI DEFAULT

PM DEFAULT

Mddata DEFAULT

IX DEFAULT

SH DEFAULT

DIP DEFAULT

2, Profile Management password security

09:10:28 sql> SELECT * from Dba_profiles;

Profile Resource_name RESOURCE LIMIT

------------------------------ -------------------------------- -------- ----------------------------------------

DEFAULT failed_login_attempts PASSWORD 10

DEFAULT Password_life_time PASSWORD Unlimited

DEFAULT Password_reuse_time PASSWORD Unlimited

DEFAULT Password_reuse_max PASSWORD Unlimited

DEFAULT password_verify_function PASSWORD NULL

DEFAULT Password_lock_time PASSWORD Unlimited

DEFAULT Password_grace_time PASSWORD Unlimited

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/