3 Replies Latest reply on Oct 11, 2017 4:13 PM by Jibu-Oracle

    EBS_APPS DBA PROFILE in 12.2.4

    User227901

      Hi,

       

      can you please provide more information regarding EBS_APPS dba profile option as i want to profile option to DEFAULT for below users. i check in metalink and couldn't find much information

       

       

      SQL> select username,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE from dba_users where PROFILE='EBS_APPS';

      USERNAME                                 ACCOUNT_STATUS                   EXPIRY_DATE        PROFILE

      ---------------------------------------- -------------------------------- ------------------ ---------------

      APPLSYS                                  OPEN                                                EBS_APPS

      APPS_NE                                  OPEN                                                EBS_APPS

      APPS                                     OPEN                                                EBS_APPS

       

      SQL> select * from dba_profiles where PROFILE='EBS_APPS';

       

       

      PROFILE         RESOURCE_NAME                    RESOURCE LIMIT                                                                                                                            COM

      --------------- -------------------------------- -------- -------------------------------------------------------------------------------------------------------------------------------- ---

      EBS_APPS        COMPOSITE_LIMIT                  KERNEL   UNLIMITED                                                                                                                        NO

      EBS_APPS        SESSIONS_PER_USER                KERNEL   UNLIMITED                                                                                                                        NO

      EBS_APPS        CPU_PER_SESSION                  KERNEL   UNLIMITED                                                                                                                        NO

      EBS_APPS        CPU_PER_CALL                     KERNEL   UNLIMITED                                                                                                                        NO

      EBS_APPS        LOGICAL_READS_PER_SESSION        KERNEL   UNLIMITED                                                                                                                        NO

      EBS_APPS        LOGICAL_READS_PER_CALL           KERNEL   UNLIMITED                                                                                                                        NO

      EBS_APPS        IDLE_TIME                        KERNEL   UNLIMITED                                                                                                                        NO

      EBS_APPS        CONNECT_TIME                     KERNEL   UNLIMITED                                                                                                                        NO

      EBS_APPS        PRIVATE_SGA                      KERNEL   UNLIMITED                                                                                                                        NO

      EBS_APPS        FAILED_LOGIN_ATTEMPTS            PASSWORD UNLIMITED                                                                                                                        NO

      EBS_APPS        PASSWORD_LIFE_TIME               PASSWORD UNLIMITED                                                                                                                        NO

      EBS_APPS        PASSWORD_REUSE_TIME              PASSWORD UNLIMITED                                                                                                                        NO

      EBS_APPS        PASSWORD_REUSE_MAX               PASSWORD UNLIMITED                                                                                                                        NO

      EBS_APPS        PASSWORD_VERIFY_FUNCTION         PASSWORD NULL                                                                                                                             NO

      EBS_APPS        PASSWORD_LOCK_TIME               PASSWORD UNLIMITED                                                                                                                        NO

      EBS_APPS        PASSWORD_GRACE_TIME              PASSWORD UNLIMITED                                                                                                                        NO

       

      thanks,

      Abraham