Oracle SQL in 10 Minutes - Asim Abbasi
CH1: SQL Basics | CH2: SQL Operators | CH3: SQL Built-in Functions | CH4: SQL Joins | CH5: UPDATE, INSERT & DELETE Statements | CH6: CREATE, ALTER & DROP Statements | CH7: Constraints | CH8: Linking Tables vs Joining Tables | CH9: SQL Statements for Other Database Objects | CH10: SQL Statements for Database Security
Chapter 10: SQL Statements for Database Security
When the CONNECT_TIME value is exceeded Oracle rolls
back the current transaction and ends 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.
Chapter 10: SQL Statements for Database Security
CH1: SQL Basics | CH2:
SQL Operators |
CH3: SQL Built-in Functions | CH4:
SQL Joins | CH5:
UPDATE, INSERT & DELETE Statements |
CH6: CREATE, ALTER & DROP Statements | CH7:
Constraints | CH8:
Linking Tables vs Joining Tables | CH9:
SQL
Statements for Other Database Objects | CH10:
SQL Statements for
Database Security Share with others: