Database Reference
In-Depth Information
When the CONNECT_TIME value will exceed Oracle will
rollback the current transaction and then will end the session.
Example:
CREATE PROFILE hr_dept
LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
Or,
CREATE PROFILE hr_dept
LIMIT FAILED_LOGIN_ATTEMPTS 5;
I think this is self-explanatory. Besides these, the other resource
consumption
and
password
settings
are,
LOGICAL_READS_PER_CALL,
SESSIONS_PER_USER,
PASSWORD_LIFE_TIME,
PASSWORD_GRACE_TIME,
PASSWORD_LOCK_TIME,
PASSWORD_REUSE_TIME,
PASSWORD_REUSE_MAX etc.
Administration User Accounts Provided by Oracle
There are some users accounts built-in Oracle. The
administrative accounts provided by Oracle are given below.
These accounts are by default locked initially. Database
administrators can unlock these accounts. Among all these
accounts SYS and SYSTEM are necessary for basic functioning
or Oracle database.
CTXSYS: Oracle Text user
DBSNMP: Enterprise Manager Management Agent
MDDATA: Oracle Spatial account
MDSYS: Oracle Spatial account
Search WWH ::




Custom Search