Oracle users,roles,audit and security
MANAGING SECURITY Managing Profiles 1.Creating profile and Granting it to user CONN sys/password AS SYSDBA CREATE PROFILE my_profile LIMIT FAILED_LOGIN_ATTEMPTS 3 — Account locked after 3 failed logins. PASSWORD_LOCK_TIME 5 — Number of days account is locked for. UNLIMITED required explicit unlock by DBA. PASSWORD_LIFE_TIME 30 — Password expires… Continue Reading Oracle users,roles,audit and security
- Posted on:
-
Author:
debasis maity
- Categories: security
- Tags: audit oracle, roles, users
- Leave a comment: Oracle users,roles,audit and security