My Oracle Support Banner

Auditing And Password Setting In Timesten (Doc ID 2459215.1)

Last updated on OCTOBER 15, 2019

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1.8.0 and later
Information in this document applies to any platform.

Goal

1) Do Timesten database has create profile functionality like below 

CREATE PROFILE IND_PROFILE LIMIT
 SESSIONS_PER_USER 2
 CPU_PER_SESSION UNLIMITED
 CPU_PER_CALL UNLIMITED
 CONNECT_TIME UNLIMITED
 IDLE_TIME 15
 LOGICAL_READS_PER_SESSION UNLIMITED
 LOGICAL_READS_PER_CALL UNLIMITED
 COMPOSITE_LIMIT UNLIMITED
 PRIVATE_SGA UNLIMITED
 FAILED_LOGIN_ATTEMPTS 3
 PASSWORD_LIFE_TIME 90
 PASSWORD_REUSE_TIME 60
 PASSWORD_REUSE_MAX 12
 PASSWORD_LOCK_TIME 1
 PASSWORD_GRACE_TIME 7
 PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION;

2) VERIFY FUNCTION for the creation of user and password in terms of validation on the complexity? If any, How?

3) Audit Trail for tracking login sessions (both SUCCESS and FAILED)?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.