DB version: 11.2.0.4/RHEL 6.2
Currently, any user I create without specifying the PROFILE keyword, it is assigned the 'DEFAULT' profile
SQL> create user test identified by Jumbl72$; --- PROFILE keyword not used
User created.
SQL> select profile from dba_users where username = 'TEST';
PROFILE
------------------------------
DEFAULT
1 row selected.
But, I want the following profile to set automatically for any user that gets created without specifying the PROFILE keyword
SQL> CREATE PROFILE CUST_APP LIMIT
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LOCK_TIME 5
PASSWORD_LIFE_TIME 90
PASSWORD_GRACE_TIME 14
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX 5
idle_time 25 ;
Profile created.
SQL>