Managing Password Security And Resources

Password Management:

Password Verification:

Sample script for creating a password verifies function:

{ORACLE_HOME}/rdbms/admin/utlpwdmg.sql

Resource Management:

Profile Creation:

CREATE PROFILE n_user LIMIT

FAILED_LOGIN_ATTEMPTS 3

PASSWORD_LOCK_TIME UNLIMITED

PASSWORD_LIFE_TIME 20

PASSWORD_REUSE_TIME 50

PASSWORD_VERIFY_FUNCTION verify_function

PASSWORD_GRACE_TIME 5;

Alter Profile:

ALTER PROFILE n_user LIMIT

PASSWORD_LOCK_TIME 1/24

SESSIONS_PER_USER 2

IDLE_TIME 60;

Assign Profile During User Creation:

CREATE USER topu IDENTIFIED BY topu#1

PROFILE n_user;

Assigning Profile after a user creation:

SQL> CREATE USER manik IDENTIFIED BY manik#1;

SQL> ALTER USER MANIK

PROFILE n_user;

Drop Profile:

DROP PROFILE n_user;

Drop Profile with Users:

DROP PROFILE n_user CASCADE;

View the created Profile:

SELECT DISTINCT PROFILE

FROM dba_profiles;

View Information of an User Accounts:

SELECT username, expiry_date, account_status

FROM dba_users

WHERE username='TOPU';