1 2 3 4 Previous Next 50 Replies Latest reply on Jun 19, 2015 1:30 PM by Christian Neumueller-Oracle Go to original post
      • 30. Re: Cannot log into RASADM.
        Christian Neumueller-Oracle

        I doubt it, but you could log in to the APEX development environment. If this works, create an application with DB authentication and try to log in to that. Test this with normal db users and then with RAS users. Maybe one of these steps fails and we get another handle on this problem.

         

        Regards,

        Christian

        • 31. Re: Cannot log into RASADM.
          Fred C Willingham

          Christian Neumueller-Oracle wrote:

           

          I doubt it, but you could log in to the APEX development environment. If this works, create an application with DB authentication and try to log in to that. Test this with normal db users and then with RAS users. Maybe one of these steps fails and we get another handle on this problem.

           

          Regards,

          Christian

           

          Hi Christian.

           

          I can log into the APEX 5 development environment without any problems.

           

          I have created a test APEX 5 application that uses Database Authentication.

           

          I have created some RAS Application Users and I can log in directly to Oracle as those users. I can limit the rows seen by one of the users.

           

          When I try to log into an APEX 5 application that uses Database Authentication with the RAS Application Users names and passwords I get the "Unknown User Name" result. Should that be happening?

          • 32. Re: Cannot log into RASADM.
            Christian Neumueller-Oracle

            Hi Fred,

             

            can you log in to the APEX 5 application with

             

            (1) a normal database user? (create user foo ...)

            (2) a RAS user created just like in my example above?

             

            Please post the exact sqlplus output where you created these 2 users.

             

            Regards,

            Christian

            • 33. Re: Re: Cannot log into RASADM.
              Fred C Willingham

              Christian Neumueller-Oracle wrote:

               

              Hi Fred,

               

              can you log in to the APEX 5 application with

               

              (1) a normal database user? (create user foo ...)

              (2) a RAS user created just like in my example above?

               

              Please post the exact sqlplus output where you created these 2 users.

               

              Regards,

              Christian

               

              Hi Christian.

               

              can you log in to the APEX 5 application with

               

              (1) a normal database user? (create user foo ...)

               

              >> Yes

               

              (2) a RAS user created just like in my example above?

               

              >> No, I get the "Unknown User Name" Authentication result.

               

              Here's the script for the RAS Application Users:

               

              SET TIMING ON ECHO ON

              ALTER SESSION SET CURRENT_SCHEMA = arcdev;

               

              -- create a database role that provides access to the directories used by

              -- external tables

               

              CREATE ROLE arc_xtbl_dir_role;

               

              GRANT SELECT ON do_doit_box_fred_xtbl TO arc_xtbl_dir_role;

              GRANT READ,

                    WRITE

                ON DIRECTORY arc_loader_input_dir

                TO arc_xtbl_dir_role;

              GRANT READ,

                    WRITE

                ON DIRECTORY arc_loader_log_dir

                TO arc_xtbl_dir_role;

              GRANT READ,

                    WRITE

                ON DIRECTORY arc_loader_bad_dir

                TO arc_xtbl_dir_role;

              GRANT READ,

                    WRITE

                ON DIRECTORY arc_loader_dsc_dir

                TO arc_xtbl_dir_role;

               

              SELECT *

                FROM dba_roles

              WHERE role = 'ARC_XTBL_DIR_ROLE';

               

              -- create an administrative Application Role

               

              BEGIN

                xs_principal.create_role

                (

                    name        => 'arc_administrator_role',

                    enabled    => TRUE,

                    description => 'DHHS Archiving Administrative Application Role'

                );

              END;

              /

               

              GRANT arc_xtbl_dir_role TO arc_administrator_role;

               

              -- create a Concord District Office Application Role

               

              BEGIN

                xs_principal.create_role

                (

                    name        => 'arc_concord_do_role',

                    enabled    => TRUE,

                    description => 'DHHS Archiving Concord DO Application Role'

                );

              END;

              /

               

              GRANT arc_xtbl_dir_role TO arc_concord_do_role;

               

              SELECT *

                FROM dba_xs_roles

              WHERE name IN ('ARC_ADMINISTRATOR_ROLE',

                              'ARC_CONCORD_DO_ROLE');

               

              SELECT *

                FROM dba_xs_role_grants

              WHERE grantee IN ('ARC_ADMINISTRATOR_ROLE',

                                'ARC_CONCORD_DO_ROLE');

               

              -- create an administrative Application User

               

              BEGIN

                xs_principal.create_user

                (

                    name        => 'ARC_ADMIN_USER',

                    schema      => SYS_CONTEXT(

                                              'userenv',

                                              'current_schema'

                                              ),

                    description => 'DHHS Archiving Concord Administrative User'

                );

              END;

              /

               

              BEGIN

                xs_principal.set_password(

                                          'ARC_ADMIN_USER',

                                          'password'

                                          );

              END;

              /

               

              BEGIN

                xs_principal.grant_roles(

                                          'ARC_ADMIN_USER',

                                          'arc_administrator_role'

                                        );

              END;

              /

               

              BEGIN

                IF xs_diag.validate_principal(

                                              name        => 'ARC_ADMIN_USER',

                                              error_limit => 1

                                              )

                THEN

                    dbms_output.put_line('Principal validated.');

                ELSE

                    dbms_output.put_line('Principal not validated.');

                END IF;

              END;

               

              SELECT * FROM xs$validation_table;

               

              -- create a Concord District Office Application User

               

              BEGIN

                xs_principal.create_user

                (

                    name        => 'ARC_CONCORD_DO_USER',

                    schema      => SYS_CONTEXT(

                                              'userenv',

                                              'current_schema'

                                              ),

                    description => 'DHHS Archiving Concord District Office User'

                );

              END;

              /

               

              BEGIN

                xs_principal.set_password(

                                          'ARC_CONCORD_DO_USER',

                                          'password'

                                          );

              END;

              /

               

              BEGIN

                xs_principal.grant_roles(

                                          'ARC_CONCORD_DO_USER',

                                          'arc_concord_do_role'

                                        );

              END;

              /

               

              BEGIN

                IF xs_diag.validate_principal(

                                              name        => 'ARC_CONCORD_DO_USER',

                                              error_limit => 1

                                              )

                THEN

                    dbms_output.put_line('Principal validated.');

                ELSE

                    dbms_output.put_line('Principal not validated.');

                END IF;

              END;

               

              SELECT * FROM xs$validation_table;

               

              SELECT *

                FROM dba_xs_users

              WHERE name IN ('ARC_ADMIN_USER',

                              'ARC_CONCORD_DO_USER');

               

              SELECT *

                FROM dba_xs_role_grants

              WHERE grantee IN ('ARC_ADMIN_USER',

                                'ARC_CONCORD_DO_USER');

               

              -- create Security Class

               

              BEGIN

                xs_security_class.create_security_class

                (

                    name        => 'do_doit_box_fred_xtbl_class',

                    description => 'DHHS Archiving Administrative Class',

                    parent_list => xs$name_list('sys.dml'),

                    priv_list  => xs$privilege_list(

                                                    xs$privilege('VIEW_CONCORD_DO'),

                                                    xs$privilege('VIEW_NON_CONCORD_DO')

                                                    )

                );

              END;

              /

               

              BEGIN

                IF xs_diag.validate_security_class(

                                                    'DO_DOIT_BOX_FRED_XTBL_CLASS',

                                                    100

                                                  )

                THEN

                    dbms_output.put_line('The security class is valid.');

                ELSE

                    dbms_output.put_line('The security class is invalid.');

                END IF;

              END;

              /

               

              SELECT * FROM xs$validation_table;

               

              SELECT *

                FROM dba_xs_security_classes

              WHERE name IN ('DO_DOIT_BOX_FRED_XTBL_CLASS');

               

              -- create the ACLs

               

              DECLARE

                ace_list  xs$ace_list;

              BEGIN

                ace_list :=

                    xs$ace_list

                    (

                      xs$ace_type(

                                  privilege_list => xs$name_list(

                                                                  '"SELECT"',

                                                                  'VIEW_CONCORD_DO',

                                                                  'VIEW_NON_CONCORD_DO'

                                                                ),

                                  granted        => TRUE,

                                  principal_name => 'arc_administrator_role'

                                  )

                    );

               

               

                sys.xs_acl.create_acl

                (

                    name        => 'arc_administrator_acl',

                    ace_list    => ace_list,

                    sec_class  => SYS_CONTEXT(

                                              'userenv',

                                              'current_schema'

                                              )||

                                  '.do_doit_box_fred_xtbl_class',

                    description => 'do_doit_box_fred_xtbl Administrative Access Control List'

                );

              END;

              /

               

              BEGIN

                IF xs_diag.validate_acl(

                                        name        => 'arc_administrator_acl',

                                        error_limit => 100

                                        )

                THEN

                    dbms_output.put_line('ACL validated.');

                ELSE

                    dbms_output.put_line('ACL not validated.');

                END IF;

              END;

              /

               

              SELECT * FROM xs$validation_table;

               

              DECLARE

                ace_list  xs$ace_list;

              BEGIN

                ace_list :=

                    xs$ace_list(

                                xs$ace_type(

                                            privilege_list => xs$name_list(

                                                                          '"SELECT"',

                                                                          'VIEW_CONCORD_DO'

                                                                          ),

                                            granted        => TRUE,

                                            principal_name => 'arc_concord_do_role'

                                          )

                              );

               

                sys.xs_acl.create_acl

                (

                    name        => 'arc_concord_do_acl',

                    ace_list    => ace_list,

                    sec_class  => SYS_CONTEXT(

                                              'userenv',

                                              'current_schema'

                                              )||

                                  '.do_doit_box_fred_xtbl_class',

                    description => 'do_doit_box_fred_xtbl concord DO Access Control List'

                );

              END;

              /

               

              BEGIN

                IF xs_diag.validate_acl(

                                        name        => 'arc_concord_do_acl',

                                        error_limit => 100

                                        )

                THEN

                    dbms_output.put_line('ACL validated.');

                ELSE

                    dbms_output.put_line('ACL not validated.');

                END IF;

              END;

              /

               

              SELECT * FROM xs$validation_table;

               

              SELECT *

                FROM dba_xs_acls

              WHERE name IN ('ARC_ADMINISTRATOR_ACL',

                              'ARC_CONCORD_DO_ACL');

               

              -- create the Data Security Policy do_doit_box_fred_xtbl_ds

               

              DECLARE

                realms  xs$realm_constraint_list;

              BEGIN

                -- Create a data realm constraint comprising of 2 Data Realms (rules) and

                -- an associated ACL.

               

                realms := xs$realm_constraint_list();

               

                realms.EXTEND(2);

               

                -- Realm #1: All the records.

                -- arc_administrator_role can view the realm.

               

                realms(1) :=

                    xs$realm_constraint_type

                    (

                      realm    => '1=1',

                      acl_list => xs$name_list('ARC_ADMINISTRATOR_ACL')

                    );

               

                -- Realm #2: The records in the Concord District Office.

                -- arc_concord_do_role can view the realm.

               

                realms(2) :=

                    xs$realm_constraint_type(

                                            realm    => q'[office='Concord DO']',

                                            acl_list => xs$name_list('ARC_CONCORD_DO_ACL')

                                            );

               

                sys.xs_data_security.create_policy

                (

                    name                  => SYS_CONTEXT(

                                                        'userenv',

                                                        'current_schema'

                                                        )||

                                            '.DO_DOIT_BOX_FRED_XTBL_DS',

                    realm_constraint_list => realms,

                    description          => 'doit_box_fred_xtbl Data Security Policy'

                );

              END;

              /

               

               

              SELECT *

                FROM dba_xs_policies

              WHERE name = 'DO_DOIT_BOX_FRED_XTBL_DS';

               

              -- apply the Data Security Policy to the table

               

              -- Enforce the data security policy to protect READ access of the

              -- DO_DOIT_BOX_FRED_XTBL table and restrict access using the VIEW_CONCORD_DO

              -- and VIEW_NON_CONCORD_DO privileges.

               

              BEGIN

                sys.xs_data_security.apply_object_policy

                (

                    policy          => SYS_CONTEXT(

                                                  'userenv',

                                                  'current_schema'

                                                  )||

                                      '.DO_DOIT_BOX_FRED_XTBL_DS',

                    schema          => SYS_CONTEXT(

                                                  'userenv',

                                                  'current_schema'

                                                  ),

                    object          => 'DO_DOIT_BOX_FRED_XTBL',

                    statement_types => 'SELECT',

                    owner_bypass    => TRUE

                );

              END;

              /

               

              SELECT *

                FROM dba_xs_applied_policies

              WHERE policy = 'DO_DOIT_BOX_FRED_XTBL_DS';

               

              BEGIN

                IF xs_diag.validate_data_security

                    (

                      policy      => SYS_CONTEXT(

                                                  'userenv',

                                                  'current_schema'

                                                )||

                                      '.DO_DOIT_BOX_FRED_XTBL_DS',

                      table_owner => SYS_CONTEXT(

                                                  'userenv',

                                                  'current_schema'

                                                ),

                      table_name  => 'DO_DOIT_BOX_FRED_XTBL',

                      error_limit => 100

                    )

                THEN

                    dbms_output.put_line('Data Security Policy validated.');

                ELSE

                    dbms_output.put_line('Data Security Policy not validated.');

                END IF;

              END;

              /

               

              SELECT * FROM xs$validation_table;

               

              -- validate workspace.

               

              BEGIN

                IF xs_diag.validate_workspace(error_limit => 1)

                THEN

                    dbms_output.put_line('Workspace validated.');

                ELSE

                    dbms_output.put_line('Workspace not validated.');

                END IF;

              END;

              /

               

              SELECT * FROM xs$validation_table;

               

              Here's the script for the regular database user:

               

              CREATE USER DBUSER

                IDENTIFIED BY <password>

                DEFAULT TABLESPACE USERS

                TEMPORARY TABLESPACE TEMP

                PROFILE SCHEMA_PROFILE

                ACCOUNT UNLOCK;

                -- 1 Role for DBUSER

                GRANT CONNECT TO DBUSER;

                ALTER USER DBUSER DEFAULT ROLE ALL;

                -- 1 Tablespace Quota for DBUSER

                ALTER USER DBUSER QUOTA UNLIMITED ON USERS;

              • 34. Re: Re: Re: Cannot log into RASADM.
                Fred C Willingham

                SQL> ALTER SESSION SET CURRENT_SCHEMA = arcdev

                Session altered.

                Elapsed: 00:00:00.05

                SQL> -- create a database role that provides access to the directories used by

                SQL> -- external tables

                SQL> CREATE ROLE arc_xtbl_dir_role

                Role created.

                Elapsed: 00:00:00.02

                SQL> GRANT SELECT ON do_doit_box_fred_xtbl TO arc_xtbl_dir_role

                Grant complete.

                Elapsed: 00:00:00.02

                SQL> GRANT READ,

                      WRITE

                   ON DIRECTORY arc_loader_input_dir

                   TO arc_xtbl_dir_role

                Grant complete.

                Elapsed: 00:00:00.02

                SQL> GRANT READ,

                      WRITE

                   ON DIRECTORY arc_loader_log_dir

                   TO arc_xtbl_dir_role

                Grant complete.

                Elapsed: 00:00:00.02

                SQL> GRANT READ,

                      WRITE

                   ON DIRECTORY arc_loader_bad_dir

                   TO arc_xtbl_dir_role

                Grant complete.

                Elapsed: 00:00:00.02

                SQL> GRANT READ,

                      WRITE

                   ON DIRECTORY arc_loader_dsc_dir

                   TO arc_xtbl_dir_role

                Grant complete.

                Elapsed: 00:00:00.02

                SQL> SELECT *

                  FROM dba_roles

                WHERE role = 'ARC_XTBL_DIR_ROLE'

                 

                 

                ROLE                                                                           

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

                PASSWORD_REQUIRED AUTHENTICATION_TYPE COMMON ORACLE_MAINTAINED

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

                ARC_XTBL_DIR_ROLE                                                              

                NO                NONE                NO     N               

                                                                                               

                1 row selected.

                Elapsed: 00:00:00.03

                SQL> -- create an administrative Application Role

                SQL> BEGIN

                   xs_principal.create_role

                   (

                      name        => 'arc_administrator_role',

                      enabled     => TRUE,

                      description => 'DHHS Archiving Administrative Application Role'

                   );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.03

                SQL> GRANT arc_xtbl_dir_role TO arc_administrator_role

                Grant complete.

                Elapsed: 00:00:00.05

                SQL> -- create a Concord District Office Application Role

                SQL> BEGIN

                   xs_principal.create_role

                   (

                      name        => 'arc_concord_do_role',

                      enabled     => TRUE,

                      description => 'DHHS Archiving Concord DO Application Role'

                   );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:01.02

                SQL> GRANT arc_xtbl_dir_role TO arc_concord_do_role

                Grant complete.

                Elapsed: 00:00:00.02

                SQL> SELECT *

                  FROM dba_xs_roles

                WHERE name IN ('ARC_ADMINISTRATOR_ROLE',

                                'ARC_CONCORD_DO_ROLE')

                 

                 

                NAME                                                                           

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

                GUID                           

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

                EXTERNAL_SOURCE                                                                

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

                DEFAULT_ENABLED START_DATE                        

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

                END_DATE                          

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

                DESCRIPTION                                                                    

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

                ARC_ADMINISTRATOR_ROLE                                                         

                                               

                                                                                               

                YES                                               

                                                  

                DHHS Archiving Administrative Application Role                                 

                                                                                               

                ARC_CONCORD_DO_ROLE                                                            

                                               

                                                                                               

                YES                                               

                 

                 

                NAME                                                                           

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

                GUID                           

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

                EXTERNAL_SOURCE                                                                

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

                DEFAULT_ENABLED START_DATE                        

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

                END_DATE                          

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

                DESCRIPTION                                                                    

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

                                                  

                DHHS Archiving Concord DO Application Role                                     

                                                                                               

                 

                 

                2 rows selected.

                Elapsed: 00:00:00.03

                SQL> SELECT *

                  FROM dba_xs_role_grants

                WHERE grantee IN ('ARC_ADMINISTRATOR_ROLE',

                                   'ARC_CONCORD_DO_ROLE')

                 

                 

                GRANTEE                                                                        

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

                GRANTED_ROLE                                                                   

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

                GRANTED_ROLE_TYPE START_DATE                        

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

                END_DATE                          

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

                ARC_ADMINISTRATOR_ROLE                                                         

                ARC_XTBL_DIR_ROLE                                                              

                DATABASE                                            

                                                  

                                                                                               

                ARC_CONCORD_DO_ROLE                                                            

                ARC_XTBL_DIR_ROLE                                                              

                DATABASE                                            

                                                  

                                                                                               

                 

                 

                2 rows selected.

                Elapsed: 00:00:00.04

                SQL> -- create an administrative Application User

                SQL> BEGIN

                   xs_principal.create_user

                   (

                      name        => 'ARC_ADMIN_USER',

                      schema      => SYS_CONTEXT(

                                                 'userenv',

                                                 'current_schema'

                                                ),

                      description => 'DHHS Archiving Concord Administrative User'

                   );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.03

                SQL> BEGIN

                   xs_principal.set_password(

                                             'ARC_ADMIN_USER',

                                             'password'

                                            );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.03

                SQL> BEGIN

                   xs_principal.grant_roles(

                                            'ARC_ADMIN_USER',

                                            'arc_administrator_role'

                                           );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.02

                SQL> BEGIN

                   IF xs_diag.validate_principal(

                                                 name        => 'ARC_ADMIN_USER',

                                                 error_limit => 1

                                                )

                   THEN

                      dbms_output.put_line('Principal validated.');

                   ELSE

                      dbms_output.put_line('Principal not validated.');

                   END IF;

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.04

                SQL> SELECT * FROM xs$validation_table

                no rows selected.

                Elapsed: 00:00:00.03

                SQL> -- create a Concord District Office Application User

                SQL> BEGIN

                   xs_principal.create_user

                   (

                      name        => 'ARC_CONCORD_DO_USER',

                      schema      => SYS_CONTEXT(

                                                 'userenv',

                                                 'current_schema'

                                                ),

                      description => 'DHHS Archiving Concord District Office User'

                   );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.02

                SQL> BEGIN

                   xs_principal.set_password(

                                             'ARC_CONCORD_DO_USER',

                                             'password'

                                            );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.03

                SQL> BEGIN

                   xs_principal.grant_roles(

                                            'ARC_CONCORD_DO_USER',

                                            'arc_concord_do_role'

                                           );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.02

                SQL> BEGIN

                   IF xs_diag.validate_principal(

                                                 name        => 'ARC_CONCORD_DO_USER',

                                                 error_limit => 1

                                                )

                   THEN

                      dbms_output.put_line('Principal validated.');

                   ELSE

                      dbms_output.put_line('Principal not validated.');

                   END IF;

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.03

                SQL> SELECT * FROM xs$validation_table

                no rows selected.

                Elapsed: 00:00:00.03

                SQL> SELECT *

                  FROM dba_xs_users

                WHERE name IN ('ARC_ADMIN_USER',

                                'ARC_CONCORD_DO_USER')

                 

                 

                NAME                                                                           

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

                GUID                           

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

                EXTERNAL_SOURCE                                                                

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

                ROLES_DEFAULT_ENABLED STATUS   ACCOUNT_STATUS                   LOCK_DATE

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

                EXPIRY_DATE

                -----------

                PROFILE                                                                        

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

                SCHEMA                                                                         

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

                START_DATE                          END_DATE                          

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

                DIRECT_LOGON_USER VERIFIER_TYPE

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

                DESCRIPTION                                                                    

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

                ARC_CONCORD_DO_USER                                                            

                                               

                                                                                               

                 

                 

                NAME                                                                           

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

                GUID                           

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

                EXTERNAL_SOURCE                                                                

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

                ROLES_DEFAULT_ENABLED STATUS   ACCOUNT_STATUS                   LOCK_DATE

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

                EXPIRY_DATE

                -----------

                PROFILE                                                                        

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

                SCHEMA                                                                         

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

                START_DATE                          END_DATE                          

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

                DIRECT_LOGON_USER VERIFIER_TYPE

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

                DESCRIPTION                                                                    

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

                NO                    ACTIVE   OPEN                                     

                          

                DEFAULT                                                                        

                 

                 

                NAME                                                                           

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

                GUID                           

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

                EXTERNAL_SOURCE                                                                

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

                ROLES_DEFAULT_ENABLED STATUS   ACCOUNT_STATUS                   LOCK_DATE

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

                EXPIRY_DATE

                -----------

                PROFILE                                                                        

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

                SCHEMA                                                                         

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

                START_DATE                          END_DATE                          

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

                DIRECT_LOGON_USER VERIFIER_TYPE

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

                DESCRIPTION                                                                    

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

                ARCDEV                                                                         

                                                                                      

                YES               SHA512      

                 

                 

                NAME                                                                           

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

                GUID                           

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

                EXTERNAL_SOURCE                                                                

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

                ROLES_DEFAULT_ENABLED STATUS   ACCOUNT_STATUS                   LOCK_DATE

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

                EXPIRY_DATE

                -----------

                PROFILE                                                                        

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

                SCHEMA                                                                         

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

                START_DATE                          END_DATE                          

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

                DIRECT_LOGON_USER VERIFIER_TYPE

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

                DESCRIPTION                                                                    

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

                DHHS Archiving Concord District Office User                                    

                                                                                               

                ARC_ADMIN_USER                                                                 

                 

                 

                NAME                                                                           

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

                GUID                           

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

                EXTERNAL_SOURCE                                                                

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

                ROLES_DEFAULT_ENABLED STATUS   ACCOUNT_STATUS                   LOCK_DATE

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

                EXPIRY_DATE

                -----------

                PROFILE                                                                        

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

                SCHEMA                                                                         

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

                START_DATE                          END_DATE                          

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

                DIRECT_LOGON_USER VERIFIER_TYPE

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

                DESCRIPTION                                                                    

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

                                               

                                                                                               

                NO                    ACTIVE   OPEN                                     

                 

                 

                NAME                                                                           

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

                GUID                           

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

                EXTERNAL_SOURCE                                                                

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

                ROLES_DEFAULT_ENABLED STATUS   ACCOUNT_STATUS                   LOCK_DATE

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

                EXPIRY_DATE

                -----------

                PROFILE                                                                        

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

                SCHEMA                                                                         

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

                START_DATE                          END_DATE                          

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

                DIRECT_LOGON_USER VERIFIER_TYPE

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

                DESCRIPTION                                                                    

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

                          

                DEFAULT                                                                        

                ARCDEV                                                                         

                 

                 

                NAME                                                                           

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

                GUID                           

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

                EXTERNAL_SOURCE                                                                

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

                ROLES_DEFAULT_ENABLED STATUS   ACCOUNT_STATUS                   LOCK_DATE

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

                EXPIRY_DATE

                -----------

                PROFILE                                                                        

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

                SCHEMA                                                                         

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

                START_DATE                          END_DATE                          

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

                DIRECT_LOGON_USER VERIFIER_TYPE

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

                DESCRIPTION                                                                    

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

                                                                                      

                YES               SHA512      

                DHHS Archiving Concord Administrative User                                     

                 

                 

                NAME                                                                           

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

                GUID                           

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

                EXTERNAL_SOURCE                                                                

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

                ROLES_DEFAULT_ENABLED STATUS   ACCOUNT_STATUS                   LOCK_DATE

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

                EXPIRY_DATE

                -----------

                PROFILE                                                                        

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

                SCHEMA                                                                         

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

                START_DATE                          END_DATE                          

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

                DIRECT_LOGON_USER VERIFIER_TYPE

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

                DESCRIPTION                                                                    

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

                                                                                               

                 

                 

                2 rows selected.

                Elapsed: 00:00:00.03

                SQL> SELECT *

                  FROM dba_xs_role_grants

                WHERE grantee IN ('ARC_ADMIN_USER',

                                   'ARC_CONCORD_DO_USER')

                 

                 

                GRANTEE                                                                        

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

                GRANTED_ROLE                                                                   

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

                GRANTED_ROLE_TYPE START_DATE                        

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

                END_DATE                          

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

                ARC_ADMIN_USER                                                                 

                ARC_ADMINISTRATOR_ROLE                                                         

                APPLICATION                                         

                                                  

                                                                                               

                ARC_ADMIN_USER                                                                 

                XSPUBLIC                                                                       

                APPLICATION                                         

                                                  

                                                                                               

                ARC_CONCORD_DO_USER                                                            

                ARC_CONCORD_DO_ROLE                                                            

                APPLICATION                                         

                                                  

                                                                                               

                 

                 

                GRANTEE                                                                        

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

                GRANTED_ROLE                                                                   

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

                GRANTED_ROLE_TYPE START_DATE                        

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

                END_DATE                          

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

                ARC_CONCORD_DO_USER                                                            

                XSPUBLIC                                                                       

                APPLICATION                                         

                                                  

                                                                                               

                 

                 

                4 rows selected.

                Elapsed: 00:00:00.04

                SQL> -- create Security Class

                SQL> BEGIN

                   xs_security_class.create_security_class

                   (

                      name        => 'do_doit_box_fred_xtbl_class',

                      description => 'DHHS Archiving Administrative Class',

                      parent_list => xs$name_list('sys.dml'),

                      priv_list   => xs$privilege_list(

                                                       xs$privilege('VIEW_CONCORD_DO'),

                                                       xs$privilege('VIEW_NON_CONCORD_DO')

                                                      )

                   );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.03

                SQL> BEGIN

                   IF xs_diag.validate_security_class(

                                                      'DO_DOIT_BOX_FRED_XTBL_CLASS',

                                                      100

                                                     )

                   THEN

                      dbms_output.put_line('The security class is valid.');

                   ELSE

                      dbms_output.put_line('The security class is invalid.');

                   END IF;

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.03

                SQL> SELECT * FROM xs$validation_table

                no rows selected.

                Elapsed: 00:00:00.04

                SQL> SELECT *

                  FROM dba_xs_security_classes

                WHERE name IN ('DO_DOIT_BOX_FRED_XTBL_CLASS')

                 

                 

                NAME                                                                           

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

                OWNER                                                                          

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

                DESCRIPTION                                                                    

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

                DO_DOIT_BOX_FRED_XTBL_CLASS                                                    

                ARCDEV                                                                         

                DHHS Archiving Administrative Class                                            

                                                                                               

                1 row selected.

                Elapsed: 00:00:00.03

                SQL> -- create the ACLs

                SQL> DECLARE

                   ace_list   xs$ace_list;

                BEGIN

                   ace_list :=

                      xs$ace_list

                      (

                         xs$ace_type(

                                     privilege_list => xs$name_list(

                                                                    '"SELECT"',

                                                                    'VIEW_CONCORD_DO',

                                                                    'VIEW_NON_CONCORD_DO'

                                                                   ),

                                     granted        => TRUE,

                                     principal_name => 'arc_administrator_role'

                                    )

                      );

                 

                 

                   sys.xs_acl.create_acl

                   (

                      name        => 'arc_administrator_acl',

                      ace_list    => ace_list,

                      sec_class   => SYS_CONTEXT(

                                                 'userenv',

                                                 'current_schema'

                                                )||

                                     '.do_doit_box_fred_xtbl_class',

                      description => 'do_doit_box_fred_xtbl Administrative Access Control List'

                   );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:01.03

                SQL> BEGIN

                   IF xs_diag.validate_acl(

                                           name        => 'arc_administrator_acl',

                                           error_limit => 100

                                          )

                   THEN

                      dbms_output.put_line('ACL validated.');

                   ELSE

                      dbms_output.put_line('ACL not validated.');

                   END IF;

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.03

                SQL> SELECT * FROM xs$validation_table

                no rows selected.

                Elapsed: 00:00:00.03

                SQL> DECLARE

                   ace_list   xs$ace_list;

                BEGIN

                   ace_list :=

                      xs$ace_list(

                                  xs$ace_type(

                                              privilege_list => xs$name_list(

                                                                             '"SELECT"',

                                                                             'VIEW_CONCORD_DO'

                                                                            ),

                                              granted        => TRUE,

                                              principal_name => 'arc_concord_do_role'

                                             )

                                 );

                 

                 

                   sys.xs_acl.create_acl

                   (

                      name        => 'arc_concord_do_acl',

                      ace_list    => ace_list,

                      sec_class   => SYS_CONTEXT(

                                                 'userenv',

                                                 'current_schema'

                                                )||

                                     '.do_doit_box_fred_xtbl_class',

                      description => 'do_doit_box_fred_xtbl concord DO Access Control List'

                   );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.03

                SQL> BEGIN

                   IF xs_diag.validate_acl(

                                           name        => 'arc_concord_do_acl',

                                           error_limit => 100

                                          )

                   THEN

                      dbms_output.put_line('ACL validated.');

                   ELSE

                      dbms_output.put_line('ACL not validated.');

                   END IF;

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.03

                SQL> SELECT * FROM xs$validation_table

                no rows selected.

                Elapsed: 00:00:00.03

                SQL> SELECT *

                  FROM dba_xs_acls

                WHERE name IN ('ARC_ADMINISTRATOR_ACL',

                                'ARC_CONCORD_DO_ACL')

                 

                 

                NAME                                                                           

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

                OWNER                                                                          

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

                SECURITY_CLASS                                                                 

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

                SECURITY_CLASS_OWNER                                                           

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

                PARENT_ACL                                                                     

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

                PARENT_ACL_OWNER                                                               

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

                INHERITANCE_TYPE

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

                DESCRIPTION                                                                    

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

                ARC_ADMINISTRATOR_ACL                                                          

                ARCDEV                                                                         

                DO_DOIT_BOX_FRED_XTBL_CLASS                                                    

                ARCDEV                                                                         

                                                                                               

                                                                                               

                NONE           

                 

                 

                NAME                                                                           

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

                OWNER                                                                          

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

                SECURITY_CLASS                                                                 

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

                SECURITY_CLASS_OWNER                                                           

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

                PARENT_ACL                                                                     

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

                PARENT_ACL_OWNER                                                               

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

                INHERITANCE_TYPE

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

                DESCRIPTION                                                                    

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

                do_doit_box_fred_xtbl Administrative Access Control List                       

                                                                                               

                ARC_CONCORD_DO_ACL                                                             

                ARCDEV                                                                         

                DO_DOIT_BOX_FRED_XTBL_CLASS                                                    

                ARCDEV                                                                         

                                                                                               

                 

                 

                NAME                                                                           

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

                OWNER                                                                          

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

                SECURITY_CLASS                                                                 

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

                SECURITY_CLASS_OWNER                                                           

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

                PARENT_ACL                                                                     

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

                PARENT_ACL_OWNER                                                               

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

                INHERITANCE_TYPE

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

                DESCRIPTION                                                                    

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

                                                                                               

                NONE           

                do_doit_box_fred_xtbl concord DO Access Control List                           

                                                                                               

                 

                 

                2 rows selected.

                Elapsed: 00:00:00.03

                SQL> -- create the Data Security Policy do_doit_box_fred_xtbl_ds

                SQL> DECLARE

                   realms   xs$realm_constraint_list;

                BEGIN

                   -- Create a data realm constraint comprising of 2 Data Realms (rules) and

                   -- an associated ACL.

                 

                 

                   realms := xs$realm_constraint_list();

                 

                 

                   realms.EXTEND(2);

                 

                 

                   -- Realm #1: All the records.

                   -- arc_administrator_role can view the realm.

                 

                 

                   realms(1) :=

                      xs$realm_constraint_type

                      (

                         realm    => '1=1',

                         acl_list => xs$name_list('ARC_ADMINISTRATOR_ACL')

                      );

                 

                 

                   -- Realm #2: The records in the Concord District Office.

                   -- arc_concord_do_role can view the realm.

                 

                 

                   realms(2) :=

                      xs$realm_constraint_type(

                                               realm    => q'[office='Concord DO']',

                                               acl_list => xs$name_list('ARC_CONCORD_DO_ACL')

                                              );

                 

                 

                   sys.xs_data_security.create_policy

                   (

                      name                  => SYS_CONTEXT(

                                                           'userenv',

                                                           'current_schema'

                                                          )||

                                               '.DO_DOIT_BOX_FRED_XTBL_DS',

                      realm_constraint_list => realms,

                      description           => 'doit_box_fred_xtbl Data Security Policy'

                   );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.04

                SQL> SELECT *

                  FROM dba_xs_policies

                WHERE name = 'DO_DOIT_BOX_FRED_XTBL_DS'

                 

                 

                NAME                                                                           

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

                OWNER                                                                          

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

                CREATE_TIME                                      

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

                MODIFY_TIME                                      

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

                DESCRIPTION                                                                    

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

                DO_DOIT_BOX_FRED_XTBL_DS                                                       

                ARCDEV                                                                         

                6/17/2015 3:30:26.879396 PM                      

                6/17/2015 3:30:26.879396 PM                      

                doit_box_fred_xtbl Data Security Policy                                        

                                                                                               

                1 row selected.

                Elapsed: 00:00:00.03

                SQL> -- apply the Data Security Policy to the table

                SQL> -- Enforce the data security policy to protect READ access of the

                SQL> -- DO_DOIT_BOX_FRED_XTBL table and restrict access using the VIEW_CONCORD_DO

                SQL> -- and VIEW_NON_CONCORD_DO privileges.

                SQL> BEGIN

                   sys.xs_data_security.apply_object_policy

                   (

                      policy          => SYS_CONTEXT(

                                                     'userenv',

                                                     'current_schema'

                                                    )||

                                         '.DO_DOIT_BOX_FRED_XTBL_DS',

                      schema          => SYS_CONTEXT(

                                                     'userenv',

                                                     'current_schema'

                                                    ),

                      object          => 'DO_DOIT_BOX_FRED_XTBL',

                      statement_types => 'SELECT',

                      owner_bypass    => TRUE

                   );

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.03

                SQL> SELECT *

                  FROM dba_xs_applied_policies

                WHERE policy = 'DO_DOIT_BOX_FRED_XTBL_DS'

                 

                 

                SCHEMA                                                                         

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

                OBJECT                                                                         

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

                POLICY                                                                         

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

                POLICY_OWNER                                                                   

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

                SEL INS UPD DEL IDX ROW_ACL OWNER_BYPASS STATUS 

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

                ARCDEV                                                                         

                DO_DOIT_BOX_FRED_XTBL                                                          

                DO_DOIT_BOX_FRED_XTBL_DS                                                       

                ARCDEV                                                                         

                YES NO  NO  NO  NO  NO      YES          ENABLED

                                                                                               

                1 row selected.

                Elapsed: 00:00:00.03

                SQL> BEGIN

                   IF xs_diag.validate_data_security

                      (

                         policy      => SYS_CONTEXT(

                                                    'userenv',

                                                    'current_schema'

                                                   )||

                                        '.DO_DOIT_BOX_FRED_XTBL_DS',

                         table_owner => SYS_CONTEXT(

                                                    'userenv',

                                                    'current_schema'

                                                   ),

                         table_name  => 'DO_DOIT_BOX_FRED_XTBL',

                         error_limit => 100

                      )

                   THEN

                      dbms_output.put_line('Data Security Policy validated.');

                   ELSE

                      dbms_output.put_line('Data Security Policy not validated.');

                   END IF;

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:00.20

                SQL> SELECT * FROM xs$validation_table

                no rows selected.

                Elapsed: 00:00:00.03

                SQL> -- validate workspace.

                SQL> BEGIN

                   IF xs_diag.validate_workspace(error_limit => 1)

                   THEN

                      dbms_output.put_line('Workspace validated.');

                   ELSE

                      dbms_output.put_line('Workspace not validated.');

                   END IF;

                END;

                PL/SQL procedure successfully completed.

                Elapsed: 00:00:01.16

                SQL> SELECT * FROM xs$validation_table

                no rows selected.

                Elapsed: 00:00:00.02

                • 35. Re: Re: Re: Cannot log into RASADM.
                  Christian Neumueller-Oracle

                  Hi Fred,

                   

                  in your last replies were so many moving parts, can you please provide a trivial example instead?

                   

                  Regards,
                  Christian

                  • 36. Re: Re: Re: Re: Cannot log into RASADM.
                    Fred C Willingham

                    Christian Neumueller-Oracle wrote:

                     

                    Hi Fred,

                     

                    in your last replies were so many moving parts, can you please provide a trivial example instead?

                     

                    Regards,
                    Christian

                     

                    Hi Christian.

                     

                    Here is a simpler example. I have created a RAS Application USer and a regular database user. I can log into the database directly as either one. I can log into an APEX application that is using a Database Authentication Scheme with the regular database user but I get "Unknown User name" Authentication Status.

                     

                    Here's the code used to create the users:

                     

                    SET TIMING ON ECHO ON

                     

                    EXEC xs_principal.create_role(name => 'SIMPLE_TEST_ROLE',enabled => TRUE);

                     

                    GRANT arc_xtbl_role TO simple_test_role;

                     

                    EXEC xs_principal.create_user(name => 'SIMPLE_TEST_APP_USER', schema => 'ARCDEV');

                     

                    EXEC xs_principal.set_password(user => 'SIMPLE_TEST_APP_USER', password => 'password');

                     

                    EXEC xs_principal.grant_roles(grantee => 'SIMPLE_TEST_APP_USER', role => 'SIMPLE_TEST_ROLE');

                     

                    BEGIN

                       xs_security_class.create_security_class

                       (

                          name        => 'SIMPLE_TEST_CLASS',

                          parent_list => xs$name_list('sys.dml'),

                          priv_list   => xs$privilege_list(xs$privilege('VIEW_ROWS'))

                       );

                    END;

                    /

                     

                    BEGIN

                       xs_acl.create_acl

                       (

                          name      => 'SIMPLE_TEST_ACL',

                          ace_list  => xs$ace_list

                                      (

                                         xs$ace_type(

                                                     privilege_list => xs$name_list(

                                                                                    '"SELECT"',

                                                                                    'VIEW_ROWS'

                                                                                   ),

                                                     granted        => TRUE,

                                                     principal_name => 'SIMPLE_TEST_ROLE'

                                                    )

                                      ),

                          sec_class => 'ARCDEV.SIMPLE_TEST_CLASS'

                       );

                    END;

                    /

                     

                    BEGIN

                       xs_data_security.create_policy

                       (

                          name                  => 'ARCDEV.SIMPLE_TEST_DS',

                          realm_constraint_list => xs$realm_constraint_list

                                                  (

                                                     xs$realm_constraint_type

                                                     (

                                                        realm    => '1=1',

                                                        acl_list => xs$name_list(

                                                                                 'SIMPLE_TEST_ACL'

                                                                                )

                                                     )

                                                  )

                       );

                    END;

                    /

                     

                    BEGIN

                       xs_data_security.apply_object_policy(

                                                            policy          => 'ARCDEV.SIMPLE_TEST_DS',

                                                            schema          => 'ARCDEV',

                                                            object          => 'DO_DOIT_BOX_FRED_XTBL',

                                                            statement_types => 'SELECT',

                                                            owner_bypass    => TRUE

                                                           );

                    END;

                    /

                     

                    CREATE USER simple_test_db_user

                    IDENTIFIED BY password

                    DEFAULT TABLESPACE users

                    TEMPORARY TABLESPACE temp

                    PROFILE schema_profile

                    ACCOUNT UNLOCK;

                     

                    GRANT CONNECT TO simple_test_db_user;

                    GRANT arc_xtbl_role TO simple_test_db_user;

                    ALTER USER simple_test_db_user DEFAULT ROLE ALL;

                     

                    ALTER USER simple_test_db_user QUOTA UNLIMITED ON users;

                     

                    Here are the login attempts:

                     

                     

                    UserApplicationAuthentication
                    Method
                    Login DateLogin TimeAuthentication ResultIP AddressCustom
                    Status
                    Authentication Result Code
                    ADMIN4500Internal Authentication06/18/2015 09:32:58 AM41 seconds agoNormal, successful authentication172.16.134.141-0
                    SIMPLE_TEST_APP_USER100DB06/18/2015 09:14:01 AM20 minutes agoUnknown User Name172.16.134.141Invalid Login Credentials1
                    SIMPLE_TEST_DB_USER100DB06/18/2015 09:13:30 AM20 minutes agoNormal, successful authentication172.16.134.141-0
                    SYSTEM100DB06/18/2015 09:12:16 AM21 minutes agoNormal, successful authentication172.16.134.141-0
                    ADMIN100DB06/18/2015 09:11:39 AM22 minutes agoUnknown User Name172.16.134.141Invalid Login Credentials1
                    ADMIN4500Internal Authentication06/18/2015 09:11:17 AM22 minutes agoNormal, successful authentication172.16.134.141-0
                    ARC_CONCORD_DO_USER100DB06/17/2015 11:31:09 AM22 hours agoUnknown User Name172.16.134.141Invalid Login Credentials1
                    ARC_CONCORD_DO_USER100DB06/17/2015 11:30:50 AM22 hours agoUnknown User Name172.16.134.141Invalid Login Credentials1
                    ARC_CONCORD_DO_USER100DB06/17/2015 11:28:20 AM22 hours agoUnknown User Name172.16.134.141Invalid Login Credentials1
                    ARC_CONCORD_DO_USER100DB06/17/2015 11:28:11 AM22 hours agoUnknown User Name172.16.134.141Invalid Login Credentials1
                    DBUSER100DB06/17/2015 11:27:33 AM22 hours agoNormal, successful authentication172.16.134.141-0
                    DBUSER100DB06/17/2015 11:26:55 AM22 hours agoNormal, successful authentication172.16.134.141-0
                    ADMIN4500Internal Authentication06/17/2015 11:25:31 AM22 hours agoNormal, successful authentication172.16.134.141-0

                     

                    • 37. Re: Re: Re: Re: Re: Cannot log into RASADM.
                      Fred C Willingham

                      Here is the log of the failed simple_test_app_user log in:

                       

                        SECS LVL MESSAGE                                                                                    APP/PAGE SID/SGID USER      CALL_STACK1                                        CALL_STACK2

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

                      0.000 -9- CGI: PATH_INFO = /wwv_flow.accept                                                                  0~0~              %EPG_INCLUDE_MODULES.authorize:150                :20

                          0%

                      0.001 -9- HTTP://vmdhhsdworad:7777/pls/arcd                                                                  0~0~              %EPG_INCLUDE_MODULES.authorize:150                :20

                          0%    QUERY_STRING=

                                REQUEST_METHOD=POST

                                REMOTE_ADDR=172.16.134.141

                                REMOTE_USER=APEX_PUBLIC_USER

                                APEX_LISTENER_VERSION=

                                REFERER=

                                HTTP_IF_MODIFIED_SINCE=

                      0.001 -8- init cgi_var_name.count=>30                                                                        0~0~              %CGI.init:528                                      %DEBUG.enter:451

                          0%                                                                                                                            %CGI.__pkg_init:586                                %EPG_INCLUDE_MODULES.authorize:150

                                                                                                                                                        %DEBUG.log_message_internal:885                    :20

                      0.002 -8- extract_protected_cookies p_cookies_old=>ORA_WWV_APP_111=ORA_WWV-HCIFv3f5EGTuaJ1PPYRpDFEY;          0~0~              %CGI.extract_protected_cookies:469                %DEBUG.log_message_internal:885

                          0%      ORA_WWV_REMEMBER_UN=ADMIN:arcdev; ORA_WWV_USER_69409115742119=ORA_WWV-X6KbyDI7_MBtEFvpzcm                            %CGI.init:542                                      %DEBUG.enter:451

                                HzIEn; LOGIN_USERNAME_COOKIE=simple_test_db_user; ORA_WWV_APP_100=ORA_WWV-2QO0wpBVC29-rBTi                            %CGI.__pkg_init:586                                %EPG_INCLUDE_MODULES.authorize:150

                                LR5dO_k7                                                                                                                                                                  :20

                      0.002 -9- ... ORA_WWV_APP_111 (ORA_WWV-HCIFv3f5EGTuaJ1PPYRpDFEY) extracted                                    0~0~              %CGI.do_extract:448                                %DEBUG.log_message_internal:885

                          0%                                                                                                                            %CGI.extract_protected_cookies:476                %DEBUG.enter:451

                                                                                                                                                        %CGI.init:542                                      %EPG_INCLUDE_MODULES.authorize:150

                                                                                                                                                        %CGI.__pkg_init:586                                :20

                      0.002 -9- ... ORA_WWV_REMEMBER_UN (ADMIN:arcdev) extracted                                                    0~0~              %CGI.do_extract:448                                %DEBUG.log_message_internal:885

                          0%                                                                                                                            %CGI.extract_protected_cookies:476                %DEBUG.enter:451

                                                                                                                                                        %CGI.init:542                                      %EPG_INCLUDE_MODULES.authorize:150

                                                                                                                                                        %CGI.__pkg_init:586                                :20

                      0.003 -9- ... ORA_WWV_USER_69409115742119 (ORA_WWV-X6KbyDI7_MBtEFvpzcmHzIEn) extracted                        0~0~              %CGI.do_extract:448                                %DEBUG.log_message_internal:885

                          0%                                                                                                                            %CGI.extract_protected_cookies:476                %DEBUG.enter:451

                                                                                                                                                        %CGI.init:542                                      %EPG_INCLUDE_MODULES.authorize:150

                                                                                                                                                        %CGI.__pkg_init:586                                :20

                      0.003 -9- ... ORA_WWV_APP_100 (ORA_WWV-2QO0wpBVC29-rBTiLR5dO_k7) extracted                                    0~0~              %CGI.do_extract:448                                %DEBUG.log_message_internal:885

                          0%                                                                                                                            %CGI.extract_protected_cookies:488                %DEBUG.enter:451

                                                                                                                                                        %CGI.init:542                                      %EPG_INCLUDE_MODULES.authorize:150

                                                                                                                                                        %CGI.__pkg_init:586                                :20

                      0.003 -9- Cookies: LOGIN_USERNAME_COOKIE=simple_test_db_user                                                  0~0~              %EPG_INCLUDE_MODULES.authorize:150                :20

                          0%

                      0.004 -8- authorize procedure_name=>wwv_flow.accept                                                          0~0~              %EPG_INCLUDE_MODULES.authorize:150                :20

                          0%

                      0.004 -4- Reset NLS settings                                                                                  0~0~              %LANG.init_nls:596                                %.accept:5517

                          0%                                                                                                                                                                              :35

                      0.005 -4- alter session set  NLS_COMP='BINARY' NLS_SORT='BINARY' NLS_CALENDAR='GREGORIAN' NLS_TERRIT          0~0~              %LANG.init_nls:618                                %.accept:5517

                          0%    ORY='AMERICA' NLS_LANGUAGE='AMERICAN'                                                                                                                                    :35

                      0.006 -4- ...NLS: Set Decimal separator="."                                                                  0~0~              %.reset_g_nls_decimal_separator:7373              %.accept:5517

                          0%                                                                                                                            %LANG.init_nls:624                                :35

                      0.006 -4- ...NLS: Set NLS Group separator=","                                                                0~0~              %.reset_g_nls_decimal_separator:7375              %.accept:5517

                          0%                                                                                                                            %LANG.init_nls:624                                :35

                      0.007 -4- ...NLS: Set g_nls_date_format="DD-MON-RR"                                                          0~0~              %.reset_g_nls_date_format:7332                    %.accept:5517

                          0%                                                                                                                            %LANG.init_nls:625                                :35

                      0.007 -4- ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"                                      0~0~              %.reset_g_nls_date_format:7332                    %.accept:5517

                          0%                                                                                                                            %LANG.init_nls:625                                :35

                      0.007 -4- ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"                                0~0~              %.reset_g_nls_date_format:7332                    %.accept:5517

                          0%                                                                                                                            %LANG.init_nls:625                                :35

                      0.008 -4- NLS of database and client differs, characterset conversion needed                                  0~0~              %ESCAPE.init:921                                  %LANG.reset_session_time_zone:587

                          0%                                                                                                                            %ESCAPE.__pkg_init:947                            %LANG.init_nls:630

                                                                                                                                                        %LANG.alter_db_session_time_zone:211              %.accept:5517

                                                                                                                                                                                                          :35

                      0.008 -4- ...Setting session time_zone to -04:00                                                              0~0~              %LANG.alter_db_session_time_zone:211              %LANG.init_nls:630

                          0%                                                                                                                            %LANG.reset_session_time_zone:587                  %.accept:5517

                                                                                                                                                                                                          :35

                      0.009 -8- reset_nls_environment                                                                              0~0~              %DYNAMIC_EXEC.reset_nls_environment:468            %.accept:5517

                          0%                                                                                                                            %LANG.init_nls:633                                :35

                      0.009 -8- configure_trace_and_debug p_trace=>NO,p_debug=>LEVEL9                                          100 2047641~          %SECURITY.configure_trace_and_debug:3003          %.accept:5542

                          0%                                                                                                        1801726~                                                              :35

                      0.009 -8- get_by_cookie_name p_cookie_name=>ORA_WWV_USER_69409115742119                                  100 2047641~          %SESSION.get_by_cookie_name:369                    %SECURITY.fetch_settings:2993

                          0%                                                                                                        1801726~          %SECURITY.session_cookie_info_internal:662        %SECURITY.configure_trace_and_debug:3011

                                                                                                                                                        %SECURITY.user_builder_session_company:1029        %.accept:5542

                                                                                                                                                                                                          :35

                      0.009 -9- session cookie value for ORA_WWV_USER_69409115742119=ORA_WWV-X6KbyDI7_MBtEFvpzcmHzIEn          100 2047641~          %CGI.get_session_cookie_value:359                  %SECURITY.fetch_settings:2993

                          0%                                                                                                        1801726~          %SESSION.get_by_cookie_name:373                    %SECURITY.configure_trace_and_debug:3011

                                                                                                                                                        %SECURITY.session_cookie_info_internal:662        %.accept:5542

                                                                                                                                                        %SECURITY.user_builder_session_company:1029        :35

                      0.009 -9- ... loading from session table                                                                  100 2047641~          %SESSION.get_by_cookie_name:400                    %SECURITY.fetch_settings:2993

                          0%                                                                                                        1801726~          %SECURITY.session_cookie_info_internal:662        %SECURITY.configure_trace_and_debug:3011

                                                                                                                                                        %SECURITY.user_builder_session_company:1029        %.accept:5542

                                                                                                                                                                                                          :35

                      0.010 -9- ... saved g_builder_session                                                                    100 2047641~          %SESSION.get_by_cookie_name:416                    %SECURITY.fetch_settings:2993

                          0%                                                                                                        1801726~          %SECURITY.session_cookie_info_internal:662        %SECURITY.configure_trace_and_debug:3011

                                                                                                                                                        %SECURITY.user_builder_session_company:1029        %.accept:5542

                                                                                                                                                                                                          :35

                      0.010 -9- ... session=811165395567, user=ADMIN, sgid=1801726177862873 (from db)                          100 2047641~          %SESSION.get_by_cookie_name:428                    %SECURITY.fetch_settings:2993

                          0%                                                                                                        1801726~          %SECURITY.session_cookie_info_internal:662        %SECURITY.configure_trace_and_debug:3011

                                                                                                                                                        %SECURITY.user_builder_session_company:1029        %.accept:5542

                                                                                                                                                                                                          :35

                      0.010 -4- R E Q U E S T accept LOGIN                                                                      100 2047641~          %.accept:5549                                      :35

                          0%                                                                                                        1801726~

                      0.010 -8- reset                                                                                          100 2047641~          %PAGE.reset:2749                                  %.accept:5555

                          0%                                                                                                        1801726~                                                              :35

                      0.011 -8- reset                                                                                          100 2047641~          %REGION.reset:285                                  %.accept:5555

                          0%                                                                                                        1801726~          %PAGE.reset:2760                                  :35

                      0.011 -4- Metadata: Fetch application definition and shortcuts                                            100 2047641~          %.accept:5602                                      :35

                          0%                                                                                                    101 1801726~

                      0.011 -8- fetch_flow_info                                                                                100 2047641~          %META_DATA.fetch_flow_info:909                    %.accept:5603

                          0%                                                                                                    101 1801726~                                                              :35

                      0.012 -8- set_html_escaping_mode p_mode=>E                                                                100 2047641~          %ESCAPE.set_html_escaping_mode:936                %.accept:5603

                          0%                                                                                                    101 1801726~          %META_DATA.fetch_flow_info:1154                    :35

                      0.012 -9- get_friendly_workspace_url="r/arcdev/files/static/v1/", sgid=0                                  100 2047641~          %UTILITIES.get_friendly_workspace_url:13221        %.accept:5603

                          0%                                                                                                    101 1801726~          %META_DATA.fetch_flow_info:1160                    :35

                      0.012 -9- get_friendly_workspace_url="r/arcdev/100/files/static/v1/", sgid=0                              100 2047641~          %UTILITIES.get_friendly_workspace_url:13221        %META_DATA.fetch_flow_info:1167

                          0%                                                                                                    101 1801726~          %UTILITIES.get_friendly_app_url:13237              %.accept:5603

                                                                                                                                                                                                          :35

                      0.013 -8- check_request_can_be_processed                                                                  100 2047641~          %SECURITY.check_request_can_be_processed:3545      %.accept:5605

                          0%                                                                                                    101 1801726~                                                              :35

                      0.013 -9- ...check app owner "ARCDEV" is a valid workspace schema in "1801726177862873"                  100 2047641~          %SECURITY.check_request_can_be_processed:3547      %.accept:5605

                          0%                                                                                                    101 1801726~                                                              :35

                      0.013 -9- ...check app owner is a valid database schema                                                  100 2047641~          %SECURITY.check_request_can_be_processed:3560      %.accept:5605

                          0%                                                                                                    101 1801726~                                                              :35

                      0.013 -4- NLS: wwv_flow.g_flow_language_derived_from=FLOW_PRIMARY_LANGUAGE: wwv_flow.g_browser_langu      100 2047641~          %.accept:5701                                      :35

                          0%    age=en                                                                                          101 1801726~

                      0.013 -8- alter_session p_language=>en                                                                    100 2047641~          %LANG.alter_session:755                            %.accept:5708

                          0%                                                                                                    101 1801726~                                                              :35

                      0.014 -4- alter session set nls_language='AMERICAN' nls_territory='AMERICA'                              100 2047641~          %LANG.alter_session:792                            %.accept:5708

                          1%                                                                                                    101 1801726~                                                              :35

                      0.014 -4- NLS: CSV charset=WE8MSWIN1252                                                                  100 2047641~          %LANG.alter_session:795                            %.accept:5708

                          1%                                                                                                    101 1801726~                                                              :35

                      0.014 -4- ...NLS: Set Decimal separator="."                                                              100 2047641~          %.reset_g_nls_decimal_separator:7373              %.accept:5708

                          1%                                                                                                    101 1801726~          %LANG.alter_session:800                            :35

                      0.014 -4- ...NLS: Set NLS Group separator=","                                                            100 2047641~          %.reset_g_nls_decimal_separator:7375              %.accept:5708

                          1%                                                                                                    101 1801726~          %LANG.alter_session:800                            :35

                      0.014 -4- ...NLS: Set g_nls_date_format="DD-MON-RR"                                                      100 2047641~          %.reset_g_nls_date_format:7332                    %.accept:5708

                          1%                                                                                                    101 1801726~          %LANG.alter_session:801                            :35

                      0.014 -4- ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"                                  100 2047641~          %.reset_g_nls_date_format:7332                    %.accept:5708

                          1%                                                                                                    101 1801726~          %LANG.alter_session:801                            :35

                      0.014 -4- ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"                            100 2047641~          %.reset_g_nls_date_format:7332                    %.accept:5708

                          1%                                                                                                    101 1801726~          %LANG.alter_session:801                            :35

                      0.014 -4- ...metadata, fetch translated app info                                                          100 2047641~          %.accept:5714                                      :35

                          1%                                                                                                    101 1801726~

                      0.015 -8- authenticate_and_init_session p_app_id=>100,p_has_safe_url_parameters=>null                    100 2047641~          %AUTHENTICATION.authenticate_and_init_session:1183 %.accept:5728

                          1%                                                                                                    101 1801726~                                                              :35

                      0.015 -8- set_g_security_group_id p_security_group_id=>1801726177862873,p_check_host_prefix=>true        100 2047641~          %SECURITY.set_g_security_group_id:2628            %AUTHENTICATION.authenticate_and_init_session:1188

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.load_authentication:499

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.015 -8- does_host_prefix_match p_security_group_id=>1801726177862873,p_host_prefix=>,c_path_info=>      100 2047641~          %SECURITY.does_host_prefix_match:2443              %AUTHENTICATION.authenticate_and_init_session:1188

                          1%    /wwv_flow.accept                                                                                101 1801726~          %SECURITY.set_g_security_group_id:2653

                                                                                                                                                        %AUTHENTICATION.load_authentication:499            %.accept:5728

                                                                                                                                                                                                          :35

                      0.015 -8- set_workspace_id p_workspace_id=>1801726177862873                                              100 2047641~          %SESSION_CONTEXT.set_workspace_id:27              %AUTHENTICATION.authenticate_and_init_session:1188

                          1%                                                                                                    101 1801726~          %SECURITY.set_g_security_group_id:2668

                                                                                                                                                        %AUTHENTICATION.load_authentication:499            %.accept:5728

                                                                                                                                                                                                          :35

                      0.015 -9- ... authentication id=1993345499442202, sgid=1801726177862873, curr flow sgid=180172617786      100 2047641~          %AUTHENTICATION.load_authentication:503            %.accept:5728

                          1%    2873                                                                                            101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1188 :35

                      0.015 -8- get_page_info p_application_id=>100,p_page_id=>101,p_security_group_id=>1801726177862873        100 2047641~          %PAGE.get_page_info:664                            %AUTHENTICATION.authenticate_and_init_session:1188

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.load_authentication:520

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.015 -8- get_login_url p_user_interface_id=>1987534509436588,p_application_id=>100,p_security_group      100 2047641~          %USER_INTERFACE.get_login_url:301                  %AUTHENTICATION.authenticate_and_init_session:1188

                          1%    _id=>1801726177862873                                                                          101 1801726~          %AUTHENTICATION.load_authentication:531

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.015 -8- get_home_url p_user_interface_id=>1987534509436588,p_application_id=>100,p_security_group_      100 2047641~          %USER_INTERFACE.get_home_url:274                  %AUTHENTICATION.authenticate_and_init_session:1188

                          1%    id=>1801726177862873                                                                            101 1801726~          %AUTHENTICATION.load_authentication:532

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.016 -8- init_authentication_globals p_mode=>0,p_dynamic_roles=>,p_namespaces=>                          100 2047641~          %SESSION_RAS.init_authentication_globals:56        %AUTHENTICATION.authenticate_and_init_session:1188

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.load_authentication:656

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.016 -9- ... globals have been set                                                                      100 2047641~          %SESSION_RAS.init_authentication_globals:65        %AUTHENTICATION.authenticate_and_init_session:1188

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.load_authentication:656

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.016 -9- ... page is public:true, public auth:false                                                      100 2047641~          %AUTHENTICATION.load_authentication:669            %.accept:5728

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1188 :35

                      0.016 -8- rejoin_existing_sessions c_platform_rejoin_sessions=>P,p_app_id=>100,p_app_browser_frame=>      100 2047641~          %AUTHENTICATION.rejoin_existing_sessions:792      %AUTHENTICATION.authenticate_and_init_session:1188

                          1%    D,p_app_rejoin_existing_sessions=>N,p_page_info.rejoin_existing_sessions=>                      101 1801726~          %AUTHENTICATION.load_authentication:674

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.016 -9- component stack after set_component:                                                            100 2047641~          %.set_component:2955                              %AUTHENTICATION.authenticate_and_init_session:1188

                          1%    ...[1]: APEX_APPLICATION_AUTH DB                                                                101 1801726~          %AUTHENTICATION.load_authentication:680

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.016 -4- Authentication check: DB (NATIVE_DB_ACCOUNTS)                                                  100 2047641~          %AUTHENTICATION.authenticate_and_init_session:1219 %.accept:5728

                          1%                                                                                                    101 1801726~                                                              :35

                      0.016 -9- ...session id given - no rejoining                                                              100 2047641~          %AUTHENTICATION.rejoin_session:1141                %.accept:5728

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1248 :35

                      0.016 -8- attach_preliminary p_id=>2047641529119                                                          100 2047641~          %SESSION.attach_preliminary:752                    %.accept:5728

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1252 :35

                      0.016 -9- ... loading from session table                                                                  100 2047641~          %SESSION.attach_preliminary:768                    %.accept:5728

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1252 :35

                      0.017 -8- set_g_current_session id=>2047641529119,username=>nobody,security_group_id=>18017261778628      100 2047641~          %SESSION.set_g_current_session:212                %AUTHENTICATION.authenticate_and_init_session:1252

                          1%    73                                                                                              101 1801726~          %SESSION.attach_preliminary:779

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.017 -9- check session integrity: security group id matches                                              100 2047641~          %SESSION.can_be_used:154                          %AUTHENTICATION.authenticate_and_init_session:1252

                          1%                                                                                                    101 1801726~          %SESSION.set_g_current_session:225

                                                                                                                                                        %SESSION.attach_preliminary:779                    %.accept:5728

                                                                                                                                                                                                          :35

                      0.017 -8- init_session p_sessionid=>                                                                      100 2047641~          %SESSION_RAS.init_session:98                      %AUTHENTICATION.authenticate_and_init_session:1252

                          1%                                                                                                    101 1801726~          %SESSION.set_g_current_session:229

                                                                                                                                                        %SESSION.attach_preliminary:779                    %.accept:5728

                                                                                                                                                                                                          :35

                      0.017 -8- builtin_cookie_sentry p_cookie_name=>ORA_WWV_APP_100                                            100 2047641~          %SESSION.builtin_cookie_sentry:472                %.accept:5728

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1258 :35

                      0.017 -8- get_by_cookie_name p_cookie_name=>ORA_WWV_APP_100                                              100 2047641~          %SESSION.get_by_cookie_name:369                    %AUTHENTICATION.authenticate_and_init_session:1258

                          1%                                                                                                    101 1801726~          %SESSION.builtin_cookie_sentry:476

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.017 -9- session cookie value for ORA_WWV_APP_100=ORA_WWV-2QO0wpBVC29-rBTiLR5dO_k7                      100 2047641~          %CGI.get_session_cookie_value:359                  %AUTHENTICATION.authenticate_and_init_session:1258

                          1%                                                                                                    101 1801726~          %SESSION.get_by_cookie_name:373

                                                                                                                                                        %SESSION.builtin_cookie_sentry:476                %.accept:5728

                                                                                                                                                                                                          :35

                      0.017 -9- ... session=2047641529119, user=nobody, sgid=1801726177862873 (from cache)                      100 2047641~          %SESSION.get_by_cookie_name:428                    %AUTHENTICATION.authenticate_and_init_session:1258

                          1%                                                                                                    101 1801726~          %SESSION.builtin_cookie_sentry:476

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.017 -9- ... success, session id and security group id matches                                          100 2047641~          %SESSION.builtin_cookie_sentry:492                %.accept:5728

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1258 :35

                      0.017 -9- ... set user and session id in package globals                                                  100 2047641~          %SESSION.builtin_cookie_sentry:527                %.accept:5728

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1258 :35

                      0.017 -8- set_g_security_group_id p_security_group_id=>1801726177862873,p_check_host_prefix=>true        100 2047641~ nobody    %SECURITY.set_g_security_group_id:2628            %AUTHENTICATION.authenticate_and_init_session:1258

                          1%                                                                                                    101 1801726~          %SESSION.builtin_cookie_sentry:533

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.017 -9- ... already set - exit                                                                          100 2047641~ nobody    %SECURITY.set_g_security_group_id:2634            %AUTHENTICATION.authenticate_and_init_session:1258

                          1%                                                                                                    101 1801726~          %SESSION.builtin_cookie_sentry:533

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.018 -8- set_db_session_info                                                                            100 2047641~ nobody    %SECURITY.set_db_session_info:3339                %.accept:5728

                          1%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1301 :35

                      0.018 -9- ... invalid session page -> no sentry needed                                                    100 2047641~ nobody    %AUTHENTICATION.authenticate_and_init_session:1352 %.accept:5728

                          1%                                                                                                    101 1801726~                                                              :35

                      0.018 -9- ... sentry success, no verification specified                                                  100 2047641~ nobody    %AUTHENTICATION.authenticate_and_init_session:1406 %.accept:5728

                          2%                                                                                                    101 1801726~                                                              :35

                      0.018 -4- ... sentry+verification success                                                                100 2047641~ nobody    %AUTHENTICATION.authenticate_and_init_session:1414 %.accept:5728

                          2%                                                                                                    101 1801726~                                                              :35

                      0.018 -8- create_or_reuse_session                                                                        100 2047641~ nobody    %SESSION.create_or_reuse_session:797              %.accept:5728

                          2%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1457 :35

                      0.018 -4- ...Session ID 2047641529119 can be used                                                        100 2047641~ nobody    %SESSION.create_or_reuse_session:837              %.accept:5728

                          2%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1457 :35

                      0.018 -8- init_session p_sessionid=>                                                                      100 2047641~ nobody    %SESSION_RAS.init_session:98                      %AUTHENTICATION.authenticate_and_init_session:1457

                          2%                                                                                                    101 1801726~          %SESSION.create_or_reuse_session:898

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.018 -8- init_cache                                                                                      100 2047641~ nobody    %AUTHORIZATION.init_cache:394                      %AUTHENTICATION.authenticate_and_init_session:1457

                          2%                                                                                                    101 1801726~          %SESSION.create_or_reuse_session:900

                                                                                                                                                                                                          %.accept:5728

                                                                                                                                                                                                          :35

                      0.018 -9- check session integrity: security group id matches                                              100 2047641~ nobody    %SESSION.can_be_used:154                          %SESSION.create_or_reuse_session:900

                          2%                                                                                                    101 1801726~          %SESSION.do_check_integrity:196                    %AUTHENTICATION.authenticate_and_init_session:1457

                                                                                                                                                        %SESSION.check_integrity:303

                                                                                                                                                        %AUTHORIZATION.init_cache:396                      %.accept:5728

                                                                                                                                                                                                          :35

                      0.018 -9- component stack after clear_component:                                                          100 2047641~ nobody    %.clear_component:2980                            %.accept:5728

                          2%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1557 :35

                      0.019 -8- set_user p_user=>nobody                                                                        100 2047641~ nobody    %SESSION_CONTEXT.set_user:55                      %.accept:5728

                          2%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1561 :35

                      0.019 -8- set_session_id p_session_id=>2047641529119                                                      100 2047641~ nobody    %SESSION_CONTEXT.set_session_id:41                %.accept:5728

                          2%                                                                                                    101 1801726~          %AUTHENTICATION.authenticate_and_init_session:1563 :35

                      0.019 -9- check session integrity: security group id matches                                              100 2047641~ nobody    %SESSION.can_be_used:154                          %SESSION_STATE.do_raw_substitutions:2511

                          2%                                                                                                    101 1801726~          %SESSION.can_be_used:185                          %.accept:5761

                                                                                                                                                        %SESSION_STATE.fetch_into_substitution_cache:1764  :35

                      0.019 -4- ...fetch session state from database                                                            100 2047641~ nobody    %SESSION_STATE.fetch_into_substitution_cache:1778  %.accept:5761

                          2%                                                                                                    101 1801726~          %SESSION_STATE.do_raw_substitutions:2511          :35

                      0.019 -4- fetch items (exact)                                                                            100 2047641~ nobody    %SESSION_STATE.fetch_into_substitution_cache:1791  %.accept:5761

                          2%                                                                                                    101 1801726~          %SESSION_STATE.do_raw_substitutions:2511          :35

                      0.019 -9- ... fetched 1988133009436595: name=P101_USERNAME, value=simple_test_db_user                    100 2047641~ nobody    %SESSION_STATE.fetch_into_substitution_cache:1903  %.accept:5761

                          2%                                                                                                    101 1801726~          %SESSION_STATE.do_raw_substitutions:2511          :35

                      0.019 -4- ...Setting session time_zone to -04:00                                                          100 2047641~ nobody    %LANG.alter_db_session_time_zone:211              %.accept:5852

                          2%                                                                                                    101 1801726~          %LANG.reset_session_time_zone:587                  :35

                      0.019 -4- ...Check for session expiration:                                                                100 2047641~ nobody    %SESSION.check_session_timeout_show:1436          %.accept:5864

                          2%                                                                                                    101 1801726~          %SESSION.check_session_timeout_accept:1470        :35

                      0.020 -9- ... session idle timeout updated                                                                100 2047641~ nobody    %SESSION.update_idle_timeout:1322                  %SESSION.check_session_timeout_accept:1470

                          2%                                                                                                    101 1801726~          %SESSION.check_session_timeout_show:1457          %.accept:5864

                                                                                                                                                                                                          :35

                      0.020 -4- ...Metadata: Fetch Page, Computation, Process, and Branch                                      100 2047641~ nobody    %.accept:5871                                      :35

                          2%                                                                                                    101 1801726~

                      0.020 -8- fetch_step_info                                                                                100 2047641~ nobody    %META_DATA.fetch_step_info:589                    %.accept:5873

                          2%                                                                                                    101 1801726~                                                              :35

                      0.021 -8- add_header p_key=>Cache-Control,p_name=>Cache-Control,p_value=>no-store,p_overwrite=>true,      100 2047641~ nobody    %RESPONSE.add_header:57                            %.accept:5882

                          2%    p_is_sticky=>true                                                                              101 1801726~          %RESPONSE.cache_control:270                        :35

                      0.021 -8- add_header p_key=>Pragma Cache-Control,p_name=>Pragma,p_value=>no-cache,p_overwrite=>true,      100 2047641~ nobody    %RESPONSE.add_header:57                            %.accept:5882

                          2%    p_is_sticky=>true                                                                              101 1801726~          %RESPONSE.cache_control:276                        :35

                      0.021 -8- add_header p_key=>Expires,p_name=>Expires,p_value=>Sun, 27 Jul 1997 13:00:00 GMT,p_overwri      100 2047641~ nobody    %RESPONSE.add_header:57                            %.accept:5882

                          2%    te=>true,p_is_sticky=>true                                                                      101 1801726~          %RESPONSE.cache_control:282                        :35

                      0.021 -8- add_header p_key=>X-Frame-Options,p_name=>X-Frame-Options,p_value=>DENY,p_overwrite=>true,      100 2047641~ nobody    %RESPONSE.add_header:57                            %.accept:5884

                          2%    p_is_sticky=>true                                                                              101 1801726~          %RESPONSE.x_frame_options:317                      :35

                      0.021 -4- ...Validate item page affinity.                                                                100 2047641~ nobody    %.accept:5995                                      :35

                          2%                                                                                                    101 1801726~

                      0.021 -4- ... Compute item values                                                                        100 2047641~ nobody    %.accept:6017                                      :35

                          2%                                                                                                    101 1801726~

                      0.021 -4- ...Validate protected items.                                                                    100 2047641~ nobody    %.accept:6448                                      :35

                          2%                                                                                                    101 1801726~

                      0.021 -8- clear_page_checksum                                                                            100 2047641~ nobody    %SECURITY.clear_page_checksum:2751                %.accept:6457

                          2%                                                                                                    101 1801726~                                                              :35

                      0.021 -8- db_session_init g_db_session_init_has_run=>false,g_db_session_init_code=>                      100 2047641~ nobody    %SECURITY.db_session_init:3090                    %.accept:6528

                          2%                                                                                                    101 1801726~                                                              :35

                      0.021 -4- ...Check authorization security schemes                                                        100 2047641~ nobody    %.accept:6533                                      :35

                          2%                                                                                                    101 1801726~

                      0.021 -4- Session State: Save form items and p_arg_values                                                100 2047641~ nobody    %.accept:6649                                      :35

                          2%                                                                                                    101 1801726~

                      0.022 -9- find_item_by_index_in_page: initialized cache for 100:101: 2 entries, 4 indexes                100 2047641~ nobody    %META_DATA.find_item_by_index_in_page:2874        %SESSION_STATE.save_by_id:1680

                          2%                                                                                                    101 1801726~          %META_DATA.find_item_by_id:3047                    %.accept:6655

                                                                                                                                                                                                          :35

                      0.022 -9- check session integrity: security group id matches                                              100 2047641~ nobody    %SESSION.can_be_used:154                          %SESSION_STATE.save:1431

                          3%                                                                                                    101 1801726~          %SESSION.do_check_integrity:196                    %SESSION_STATE.save_by_id:1680

                                                                                                                                                        %SESSION.check_integrity:303                      %.accept:6655

                                                                                                                                                                                                          :35

                      0.022 -8- set_substitution_cache p_id=>1988133009436595,p_value=>***,p_name=>P101_USERNAME,p_filter=      100 2047641~ nobody    %SESSION_STATE.set_substitution_cache:825          %SESSION_STATE.save_by_id:1680

                          3%    >N,p_encrypted=>N                                                                              101 1801726~          %SESSION_STATE.save:1608                          %.accept:6655

                                                                                                                                                                                                          :35

                      0.022 -4- ...Session State: Saved Item "P101_USERNAME" New Value="simple_test_app_user"                  100 2047641~ nobody    %SESSION_STATE.save_nocache:1391                  %SESSION_STATE.save_by_id:1680

                          3%                                                                                                    101 1801726~          %SESSION_STATE.save:1653                          %.accept:6655

                                                                                                                                                                                                          :35

                      0.022 -9- check session integrity: security group id matches                                              100 2047641~ nobody    %SESSION.can_be_used:154                          %SESSION_STATE.save:1431

                          3%                                                                                                    101 1801726~          %SESSION.do_check_integrity:196                    %SESSION_STATE.save_by_id:1680

                                                                                                                                                        %SESSION.check_integrity:303                      %.accept:6655

                                                                                                                                                                                                          :35

                      0.023 -8- set_substitution_cache p_id=>1988253267436595,p_value=>***,p_name=>P101_PASSWORD,p_filter=      100 2047641~ nobody    %SESSION_STATE.set_substitution_cache:825          %SESSION_STATE.save_by_id:1680

                          3%    >N,p_encrypted=>N                                                                              101 1801726~          %SESSION_STATE.save:1608                          %.accept:6655

                                                                                                                                                                                                          :35

                      0.023 -8- run_session_process_points                                                                      100 2047641~ nobody    %.run_session_process_points:3247                  %.accept:6703

                          3%                                                                                                    101 1801726~                                                              :35

                      0.023 -8- get_executed_process_point                                                                      100 2047641~ nobody    %SESSION.get_executed_process_point:1098          %.accept:6703

                          3%                                                                                                    101 1801726~          %.run_session_process_points:3251                  :35

                      0.023 -8- perform p_process_point=>ON_SUBMIT_BEFORE_COMPUTATION                                          100 2047641~ nobody    %PROCESS.perform:245                              %.accept:6708

                          3%                                                                                                    101 1801726~                                                              :35

                      0.023 -4- Processes - point: ON_SUBMIT_BEFORE_COMPUTATION                                                100 2047641~ nobody    %PROCESS.perform:249                              %.accept:6708

                          3%                                                                                                    101 1801726~                                                              :35

                      0.023 -4- Branch point: Before Computation                                                                100 2047641~ nobody    %.do_branch:2491                                  %.accept:6718

                          3%                                                                                                    101 1801726~                                                              :35

                      0.023 -8- perform p_process_point=>AFTER_SUBMIT                                                          100 2047641~ nobody    %COMPUTATION.perform:182                          %.accept:6728

                          3%                                                                                                    101 1801726~                                                              :35

                      0.023 -4- Process point: AFTER_SUBMIT                                                                    100 2047641~ nobody    %COMPUTATION.perform:186                          %.accept:6728

                          3%                                                                                                    101 1801726~                                                              :35

                      0.023 -4- Tabs: Perform Branching for Tab Requests                                                        100 2047641~ nobody    %.accept:6735                                      :35

                          3%                                                                                                    101 1801726~

                      0.024 -4- Branch point: Before Validation                                                                100 2047641~ nobody    %.do_branch:2491                                  %.accept:6764

                          3%                                                                                                    101 1801726~                                                              :35

                      0.024 -4- Validations:                                                                                    100 2047641~ nobody    %VALIDATION.perform:896                            %.accept:6777

                          3%                                                                                                    101 1801726~                                                              :35

                      0.024 -4- Perform basic and predefined validations:                                                      100 2047641~ nobody    %VALIDATION.perform_basic_validations:555          %.accept:6777

                          3%                                                                                                    101 1801726~          %VALIDATION.perform:899                            :35

                      0.024 -9- component stack after set_component:                                                            100 2047641~ nobody    %.set_component:2955                              %VALIDATION.perform:899

                          3%    ...[1]: APEX_APPLICATION_PAGE_ITEMS P101_USERNAME                                              101 1801726~          %VALIDATION.perform_basic_validations:588          %.accept:6777

                                                                                                                                                                                                          :35

                      0.025 -8- do_get_plugin_cache_idx p_app_id=>100,p_app_security_group_id=>1801726177862873,p_plugin_t      100 2047641~ nobody    %PLUGIN.do_get_plugin_cache_idx:359                %VALIDATION.perform_basic_validations:594

                          3%    ype=>ITEM TYPE,p_name=>NATIVE_TEXT_FIELD                                                        101 1801726~          %PLUGIN.get_plugin_cache_idx:424                  %VALIDATION.perform:899

                                                                                                                                                        %PLUGIN.validate_page_item:1574                    %.accept:6777

                                                                                                                                                                                                          :35

                      0.025 -8- validate p_type=>NATIVE_TEXT_FIELD                                                              100 2047641~ nobody    %NATIVE_ITEM.validate:4624                        %VALIDATION.perform:899

                          3%                                                                                                    101 1801726~          %PLUGIN.validate_page_item:1588                    %.accept:6777

                                                                                                                                                        %VALIDATION.perform_basic_validations:594          :35

                      0.025 -9- component stack after clear_component:                                                          100 2047641~ nobody    %.clear_component:2980                            %VALIDATION.perform:899

                          3%                                                                                                    101 1801726~          %VALIDATION.perform_basic_validations:624          %.accept:6777

                                                                                                                                                                                                          :35

                      0.026 -9- component stack after set_component:                                                            100 2047641~ nobody    %.set_component:2955                              %VALIDATION.perform:899

                          3%    ...[1]: APEX_APPLICATION_PAGE_ITEMS P101_PASSWORD                                              101 1801726~          %VALIDATION.perform_basic_validations:588          %.accept:6777

                                                                                                                                                                                                          :35

                      0.026 -8- do_get_plugin_cache_idx p_app_id=>100,p_app_security_group_id=>1801726177862873,p_plugin_t      100 2047641~ nobody    %PLUGIN.do_get_plugin_cache_idx:359                %VALIDATION.perform_basic_validations:594

                          3%    ype=>ITEM TYPE,p_name=>NATIVE_PASSWORD                                                          101 1801726~          %PLUGIN.get_plugin_cache_idx:424                  %VALIDATION.perform:899

                                                                                                                                                        %PLUGIN.validate_page_item:1574                    %.accept:6777

                                                                                                                                                                                                          :35

                      0.026 -8- validate p_type=>NATIVE_PASSWORD                                                                100 2047641~ nobody    %NATIVE_ITEM.validate:4624                        %VALIDATION.perform:899

                          3%                                                                                                    101 1801726~          %PLUGIN.validate_page_item:1588                    %.accept:6777

                                                                                                                                                        %VALIDATION.perform_basic_validations:594          :35

                      0.026 -9- component stack after clear_component:                                                          100 2047641~ nobody    %.clear_component:2980                            %VALIDATION.perform:899

                          3%                                                                                                    101 1801726~          %VALIDATION.perform_basic_validations:624          %.accept:6777

                                                                                                                                                                                                          :35

                      0.026 -4- Perform custom validations:                                                                    100 2047641~ nobody    %VALIDATION.perform_custom_validations:646        %.accept:6777

                          3%                                                                                                    101 1801726~          %VALIDATION.perform:900                            :35

                      0.026 -4- Branch point: Before Processing                                                                100 2047641~ nobody    %.do_branch:2491                                  %.accept:6788

                          4%                                                                                                    101 1801726~                                                              :35

                      0.026 -8- perform p_process_point=>AFTER_SUBMIT                                                          100 2047641~ nobody    %PROCESS.perform:245                              %.accept:6796

                          4%                                                                                                    101 1801726~                                                              :35

                      0.026 -4- Processes - point: AFTER_SUBMIT                                                                100 2047641~ nobody    %PROCESS.perform:249                              %.accept:6796

                          4%                                                                                                    101 1801726~                                                              :35

                      0.027 -9- component stack after set_component:                                                            100 2047641~ nobody    %.set_component:2955                              %.accept:6796

                          4%    ...[1]: APEX_APPLICATION_PAGE_PROCESS Set Username Cookie                                      101 1801726~          %PROCESS.perform:273                              :35

                      0.027 -4- ...Process "Set Username Cookie" - Type: NATIVE_PLSQL                                          100 2047641~ nobody    %PROCESS.perform:277                              %.accept:6796

                          4%                                                                                                    101 1801726~                                                              :35

                      0.027 -8- perform_process p_id=>1988520208436596,p_type=>NATIVE_PLSQL                                    100 2047641~ nobody    %PROCESS.perform_process:154                      %.accept:6796

                          4%                                                                                                    101 1801726~          %PROCESS.perform:428                              :35

                      0.027 -8- do_get_plugin_cache_idx p_app_id=>100,p_app_security_group_id=>1801726177862873,p_plugin_t      100 2047641~ nobody    %PLUGIN.do_get_plugin_cache_idx:359                %PROCESS.perform_process:188

                          4%    ype=>PROCESS TYPE,p_name=>NATIVE_PLSQL                                                          101 1801726~          %PLUGIN.get_plugin_cache_idx:424                  %PROCESS.perform:428

                                                                                                                                                        %PLUGIN.execute_process:1990                      %.accept:6796

                                                                                                                                                                                                          :35

                      0.027 -8- execute_process p_type=>NATIVE_PLSQL,p_process.attribute_01=>                                  100 2047641~ nobody    %PROCESS_NATIVE.execute_process:1076              %PROCESS.perform:428

                          4%                                                                                                    101 1801726~          %PLUGIN.execute_process:2017                      %.accept:6796

                                                                                                                                                        %PROCESS.perform_process:188                      :35

                      0.027 -4- ...Execute Statement: begin apex_authentication.send_login_username_cookie (                    100 2047641~ nobody    %DYNAMIC_EXEC.prepare_statement:148                %PLUGIN.execute_process:2017

                          4%        p_username => lower(:P101_USERNAME) );                                                      101 1801726~          SYS.WWV_DBMS_SQL.run_block5:1009                  %PROCESS.perform_process:188

                                end;                                                                                                                  %DYNAMIC_EXEC.execute_plsql_code:889              %PROCESS.perform:428

                                                                                                                                                        %PROCESS_NATIVE.plsql:65                          %.accept:6796

                                                                                                                                                        %PROCESS_NATIVE.execute_process:1083              :35

                      0.029 -8- send name=>LOGIN_USERNAME_COOKIE,value=>simple_test_app_user,expires=>,path=>,domain=>,sec      100 2047641~ nobody    WWV_OWA_COOKIE.send:116                            %PROCESS_NATIVE.plsql:65

                          4%    ure=>,httponly=>                                                                                101 1801726~          %AUTHENTICATION_API.send_login_username_cookie:101 %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                                                                          %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      0.029 -9- component stack after clear_component:                                                          100 2047641~ nobody    %.clear_component:2980                            %.accept:6796

                          4%                                                                                                    101 1801726~          %PROCESS.perform:520                              :35

                      0.029 -9- component stack after set_component:                                                            100 2047641~ nobody    %.set_component:2955                              %.accept:6796

                          4%    ...[1]: APEX_APPLICATION_PAGE_PROCESS Login                                                    101 1801726~          %PROCESS.perform:273                              :35

                      0.029 -4- ...Process "Login" - Type: NATIVE_PLSQL                                                        100 2047641~ nobody    %PROCESS.perform:277                              %.accept:6796

                          4%                                                                                                    101 1801726~                                                              :35

                      0.029 -8- perform_process p_id=>1988438994436596,p_type=>NATIVE_PLSQL                                    100 2047641~ nobody    %PROCESS.perform_process:154                      %.accept:6796

                          4%                                                                                                    101 1801726~          %PROCESS.perform:428                              :35

                      0.030 -8- execute_process p_type=>NATIVE_PLSQL,p_process.attribute_01=>                                  100 2047641~ nobody    %PROCESS_NATIVE.execute_process:1076              %PROCESS.perform:428

                          4%                                                                                                    101 1801726~          %PLUGIN.execute_process:2017                      %.accept:6796

                                                                                                                                                        %PROCESS.perform_process:188                      :35

                      0.030 -4- ...Execute Statement: begin apex_authentication.login(                                          100 2047641~ nobody    %DYNAMIC_EXEC.prepare_statement:148                %PLUGIN.execute_process:2017

                          4%        p_username => :P101_USERNAME,                                                              101 1801726~          SYS.WWV_DBMS_SQL.run_block5:1009                  %PROCESS.perform_process:188

                                    p_password => :P101_PASSWORD );                                                                                    %DYNAMIC_EXEC.execute_plsql_code:889              %PROCESS.perform:428

                                end;                                                                                                                  %PROCESS_NATIVE.plsql:65                          %.accept:6796

                                                                                                                                                        %PROCESS_NATIVE.execute_process:1083              :35

                      0.030 -8- execute_login p_username=>SIMPLE_TEST_APP_USER,p_password=>...,p_current_app_id=>100,p_nex      100 2047641~ nobody    %AUTHENTICATION.execute_login:1678                %PROCESS_NATIVE.plsql:65

                          4%    t_app_id=>100,p_next_page_id=>,p_post_login=>false,p_builder_login_for_workspace=>              101 1801726~          %AUTHENTICATION_API.login:57                      %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        :1                                                %PLUGIN.execute_process:2017

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform_process:188

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %PROCESS.perform:428

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              %.accept:6796

                                                                                                                                                                                                          :35

                      0.030 -8- create_or_reuse_session                                                                        100 2047641~ nobody    %SESSION.create_or_reuse_session:797              %PROCESS_NATIVE.plsql:65

                          4%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1710                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      0.031 -4- ...Session ID 2047641529119 can be used                                                        100 2047641~ nobody    %SESSION.create_or_reuse_session:837              %PROCESS_NATIVE.plsql:65

                          4%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1710                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      0.031 -8- init_session p_sessionid=>                                                                      100 2047641~ nobody    %SESSION_RAS.init_session:98                      %DYNAMIC_EXEC.execute_plsql_code:889

                          4%                                                                                                    101 1801726~          %SESSION.create_or_reuse_session:898              %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1710                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.031 -8- init_cache                                                                                      100 2047641~ nobody    %AUTHORIZATION.init_cache:394                      %DYNAMIC_EXEC.execute_plsql_code:889

                          4%                                                                                                    101 1801726~          %SESSION.create_or_reuse_session:900              %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1710                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.031 -9- check session integrity: security group id matches                                              100 2047641~ nobody    %SESSION.can_be_used:154                          SYS.WWV_DBMS_SQL.run_block5:1033

                          4%                                                                                                    101 1801726~          %SESSION.do_check_integrity:196                    %DYNAMIC_EXEC.execute_plsql_code:889

                                                                                                                                                        %SESSION.check_integrity:303                      %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHORIZATION.init_cache:396                      %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %SESSION.create_or_reuse_session:900              %PLUGIN.execute_process:2017

                                                                                                                                                        %AUTHENTICATION.execute_login:1710                %PROCESS.perform_process:188

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PROCESS.perform:428

                                                                                                                                                        :1                                                %.accept:6796

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      :35

                      0.031 -8- get_current g_instance=>2047641529119                                                          100 2047641~ nobody    %SESSION.get_current:348                          %PROCESS_NATIVE.plsql:65

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1711                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      0.032 -9- ... authentication id=1993345499442202, sgid=1801726177862873, curr flow sgid=180172617786      100 2047641~ nobody    %AUTHENTICATION.load_authentication:503            %PROCESS_NATIVE.plsql:65

                          5%    2873                                                                                            101 1801726~          %AUTHENTICATION.execute_login:1755                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      0.032 -8- get_page_info p_application_id=>100,p_page_id=>101,p_security_group_id=>1801726177862873        100 2047641~ nobody    %PAGE.get_page_info:664                            %DYNAMIC_EXEC.execute_plsql_code:889

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.load_authentication:520            %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1755                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.032 -8- get_login_url p_user_interface_id=>1987534509436588,p_application_id=>100,p_security_group      100 2047641~ nobody    %USER_INTERFACE.get_login_url:301                  %DYNAMIC_EXEC.execute_plsql_code:889

                          5%    _id=>1801726177862873                                                                          101 1801726~          %AUTHENTICATION.load_authentication:531            %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1755                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.032 -8- get_home_url p_user_interface_id=>1987534509436588,p_application_id=>100,p_security_group_      100 2047641~ nobody    %USER_INTERFACE.get_home_url:274                  %DYNAMIC_EXEC.execute_plsql_code:889

                          5%    id=>1801726177862873                                                                            101 1801726~          %AUTHENTICATION.load_authentication:532            %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1755                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.032 -8- init_authentication_globals p_mode=>0,p_dynamic_roles=>,p_namespaces=>                          100 2047641~ nobody    %SESSION_RAS.init_authentication_globals:56        %DYNAMIC_EXEC.execute_plsql_code:889

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.load_authentication:656            %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1755                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.033 -9- ... globals have been set                                                                      100 2047641~ nobody    %SESSION_RAS.init_authentication_globals:65        %DYNAMIC_EXEC.execute_plsql_code:889

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.load_authentication:656            %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1755                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.033 -9- ... page is public:true, public auth:false                                                      100 2047641~ nobody    %AUTHENTICATION.load_authentication:669            %PROCESS_NATIVE.plsql:65

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1755                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      0.033 -8- rejoin_existing_sessions c_platform_rejoin_sessions=>P,p_app_id=>100,p_app_browser_frame=>      100 2047641~ nobody    %AUTHENTICATION.rejoin_existing_sessions:792      %DYNAMIC_EXEC.execute_plsql_code:889

                          5%    D,p_app_rejoin_existing_sessions=>N,p_page_info.rejoin_existing_sessions=>                      101 1801726~          %AUTHENTICATION.load_authentication:674            %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1755                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.033 -9- component stack after set_component:                                                            100 2047641~ nobody    %.set_component:2955                              %DYNAMIC_EXEC.execute_plsql_code:889

                          5%    ...[1]: APEX_APPLICATION_PAGE_PROCESS Login                                                    101 1801726~          %AUTHENTICATION.load_authentication:680            %PROCESS_NATIVE.plsql:65

                                ...[2]: APEX_APPLICATION_AUTH DB                                                                                      %AUTHENTICATION.execute_login:1755                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.033 -8- create_login_throttle p_security_group_id=>1801726177862873,p_application_id=>100,p_userna      100 2047641~ nobody    %AUTHENTICATION.create_login_throttle:2321        %PROCESS_NATIVE.plsql:65

                          5%    me=>SIMPLE_TEST_APP_USER                                                                        101 1801726~          %AUTHENTICATION.execute_login:1768                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      0.033 -8- get_workspace_sec_settings p_security_group_id=>1801726177862873,p_internal=>false              100 2047641~ nobody    %SECURITY.get_workspace_sec_settings:2836          %DYNAMIC_EXEC.execute_plsql_code:889

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.create_login_throttle:2327        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1768                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.034 -9- ... expire_accounts=false, failed_login_threshold=                                              100 2047641~ nobody    %SECURITY.get_workspace_sec_settings:2863          %DYNAMIC_EXEC.execute_plsql_code:889

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.create_login_throttle:2327        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1768                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.034 -9- ...examine failed login attempts in the last 30 minutes                                        100 2047641~ nobody    %AUTHENTICATION.create_login_throttle:2331        %PROCESS_NATIVE.plsql:65

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1768                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      0.034 -9- Method :USERNAME:: 0 failed logins, last at                                                    100 2047641~ nobody    %AUTHENTICATION.log_counter:2313                  %DYNAMIC_EXEC.execute_plsql_code:889

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.create_login_throttle:2381        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1768                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.034 -9- Method :USERNAME_IP:: 0 failed logins, last at                                                  100 2047641~ nobody    %AUTHENTICATION.log_counter:2313                  %DYNAMIC_EXEC.execute_plsql_code:889

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.create_login_throttle:2384        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1768                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.034 -9- Method :IP:: 0 failed logins, last at                                                          100 2047641~ nobody    %AUTHENTICATION.log_counter:2313                  %DYNAMIC_EXEC.execute_plsql_code:889

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.create_login_throttle:2387        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1768                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      0.035 -9- ...last failed login is too long ago, no throttling                                            100 2047641~ nobody    %AUTHENTICATION.compute:2233                      %DYNAMIC_EXEC.execute_plsql_code:889

                          5%                                                                                                    101 1801726~          %AUTHENTICATION.compute_login_throttle:2242        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.create_login_throttle:2390        %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION.execute_login:1768                %PLUGIN.execute_process:2017

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PROCESS.perform_process:188

                                                                                                                                                        :1                                                %PROCESS.perform:428

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %.accept:6796

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  :35

                      0.035 -9- ...last failed login is too long ago, no throttling                                            100 2047641~ nobody    %AUTHENTICATION.compute:2233                      %DYNAMIC_EXEC.execute_plsql_code:889

                          6%                                                                                                    101 1801726~          %AUTHENTICATION.compute_login_throttle:2242        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.create_login_throttle:2390        %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION.execute_login:1768                %PLUGIN.execute_process:2017

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PROCESS.perform_process:188

                                                                                                                                                        :1                                                %PROCESS.perform:428

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %.accept:6796

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  :35

                      0.035 -9- ...last failed login is too long ago, no throttling                                            100 2047641~ nobody    %AUTHENTICATION.compute:2233                      %DYNAMIC_EXEC.execute_plsql_code:889

                          6%                                                                                                    101 1801726~          %AUTHENTICATION.compute_login_throttle:2242        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.create_login_throttle:2390        %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION.execute_login:1768                %PLUGIN.execute_process:2017

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PROCESS.perform_process:188

                                                                                                                                                        :1                                                %PROCESS.perform:428

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %.accept:6796

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  :35

                      0.035 -8- do_get_plugin_cache_idx p_app_id=>100,p_app_security_group_id=>1801726177862873,p_plugin_t      100 2047641~ nobody    %PLUGIN.do_get_plugin_cache_idx:359                SYS.WWV_DBMS_SQL.run_block5:1033

                          6%    ype=>AUTHENTICATION TYPE,p_name=>NATIVE_DB_ACCOUNTS                                            101 1801726~          %PLUGIN.get_plugin_cache_idx:424                  %DYNAMIC_EXEC.execute_plsql_code:889

                                                                                                                                                        %PLUGIN.initialize_authentication_data:1096        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %PLUGIN.execute_authentication:2335                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION.execute_login:1790                %PLUGIN.execute_process:2017

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PROCESS.perform_process:188

                                                                                                                                                        :1                                                %PROCESS.perform:428

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %.accept:6796

                                                                                                                                                                                                          :35

                      0.035 -8- execute_native_authentication p_type=>NATIVE_DB_ACCOUNTS,username=>SIMPLE_TEST_APP_USER        100 2047641~ nobody    %AUTHENTICATION_NATIVE.execute_authentication:1087 %DYNAMIC_EXEC.execute_plsql_code:889

                          6%                                                                                                    101 1801726~                                                              %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %PLUGIN.execute_authentication:2342                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION.execute_login:1790                %PLUGIN.execute_process:2017

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PROCESS.perform_process:188

                                                                                                                                                        :1                                                %PROCESS.perform:428

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %.accept:6796

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  :35

                      1.037 -9- current redirect url:, app id=100                                                              100 2047641~ nobody    %AUTHENTICATION.execute_login:1921                %PROCESS_NATIVE.plsql:65

                          7%                                                                                                    101 1801726~          %AUTHENTICATION_API.login:57                      %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        :1                                                %PLUGIN.execute_process:2017

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform_process:188

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %PROCESS.perform:428

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              %.accept:6796

                                                                                                                                                                                                          :35

                      1.037 -9- apply_login_throttle                                                                            100 2047641~ nobody    %AUTHENTICATION.apply_login_throttle:2422          %PROCESS_NATIVE.plsql:65

                          9%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1930                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      1.037 -9- ...add another login failure and re-compute the throttle                                        100 2047641~ nobody    %AUTHENTICATION.apply_login_throttle:2436          %PROCESS_NATIVE.plsql:65

                        11%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1930                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      1.037 -9- ... USERNAME: 1 failed logins, throttling login for 5 seconds (09:14:01-09:14:01)*24*3600+      100 2047641~ nobody    %AUTHENTICATION.compute:2223                      %DYNAMIC_EXEC.execute_plsql_code:889

                        13%    5 -> allowed again at 09:14:06                                                                  101 1801726~          %AUTHENTICATION.compute_login_throttle:2242        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.apply_login_throttle:2442          %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION.execute_login:1930                %PLUGIN.execute_process:2017

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PROCESS.perform_process:188

                                                                                                                                                        :1                                                %PROCESS.perform:428

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %.accept:6796

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  :35

                      1.038 -9- ... USERNAME_IP: 1 failed logins, throttling login for 5 seconds (09:14:01-09:14:01)*24*36      100 2047641~ nobody    %AUTHENTICATION.compute:2223                      %DYNAMIC_EXEC.execute_plsql_code:889

                        14%    00+5 -> allowed again at 09:14:06                                                              101 1801726~          %AUTHENTICATION.compute_login_throttle:2242        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.apply_login_throttle:2442          %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION.execute_login:1930                %PLUGIN.execute_process:2017

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PROCESS.perform_process:188

                                                                                                                                                        :1                                                %PROCESS.perform:428

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %.accept:6796

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  :35

                      1.038 -9- ... IP: 1 failed logins, throttling login for 5 seconds (09:14:01-09:14:01)*24*3600+5 -> a      100 2047641~ nobody    %AUTHENTICATION.compute:2223                      %DYNAMIC_EXEC.execute_plsql_code:889

                        16%    llowed again at 09:14:06                                                                        101 1801726~          %AUTHENTICATION.compute_login_throttle:2242        %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.apply_login_throttle:2442          %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION.execute_login:1930                %PLUGIN.execute_process:2017

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PROCESS.perform_process:188

                                                                                                                                                        :1                                                %PROCESS.perform:428

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %.accept:6796

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  :35

                      1.038 -9- setting g_primary_language := en                                                                100 2047641~ nobody    %LANG.set_g_primary_language:533                  %DYNAMIC_EXEC.execute_plsql_code:889

                        18%                                                                                                    101 1801726~          %LANG.custom_runtime_message:1568                  %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.apply_login_throttle:2448          %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION.execute_login:1930                %PLUGIN.execute_process:2017

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PROCESS.perform_process:188

                                                                                                                                                        :1                                                %PROCESS.perform:428

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %.accept:6796

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  :35

                      1.039 -9- lov_checksum("Invalid Login Credentials<div id="apex_login_throttle_div">Please wait <span      100 2047641~ nobody    %UTILITIES.lov_checksum:8903                      %PROCESS_NATIVE.plsql:65

                        19%      id="apex_login_throttle_sec">5</span> seconds to login again.</div>" - len 144)="YXH2A7aB      101 1801726~          %AUTHENTICATION.execute_login:1940                %PROCESS_NATIVE.execute_process:1083

                                cbg3TP7fsJTeGqBfw1bihUFbFEwAcff-V4_b3eII701qvWcFUcawMHpFilxIFCStFFXQQrXGXxwX4w"                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      1.039 -4- ... Authentication failed: Invalid Login Credentials<div id="apex_login_throttle_div">Plea      100 2047641~ nobody    %AUTHENTICATION.execute_login:1950                %PROCESS_NATIVE.plsql:65

                        21%    se wait <span id="apex_login_throttle_sec">5</span> seconds to login again.</div>              101 1801726~          %AUTHENTICATION_API.login:57                      %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        :1                                                %PLUGIN.execute_process:2017

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform_process:188

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %PROCESS.perform:428

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              %.accept:6796

                                                                                                                                                                                                          :35

                      1.039 -8- log_login p_username=>SIMPLE_TEST_APP_USER,p_security_group_id=>1801726177862873,p_owner=>      100 2047641~ nobody    %AUTHENTICATION.log_login:2508                    %PROCESS_NATIVE.plsql:65

                        23%    ARCDEV,p_application_id=>100,p_authentication_method=>DB,p_authentication_result=>1,p_cust      101 1801726~          %AUTHENTICATION.execute_login:1961                %PROCESS_NATIVE.execute_process:1083

                                om_status_text=>Invalid Login Credentials                                                                              %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      1.039 -8- compute_dynamic_groups                                                                          100 2047641~ nobody    %AUTHORIZATION.compute_dynamic_groups:318          %PROCESS_NATIVE.plsql:65

                        24%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1982                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      1.040 -9- ...deleting current session groups                                                              100 2047641~ nobody    %AUTHORIZATION.compute_dynamic_groups:352          %PROCESS_NATIVE.plsql:65

                        26%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1982                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      1.040 -9- ... 0 rows                                                                                      100 2047641~ nobody    %AUTHORIZATION.compute_dynamic_groups:355          %PROCESS_NATIVE.plsql:65

                        28%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1982                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      1.040 -9- ... update session user (nobody) and auth result (1)                                            100 2047641~ nobody    %AUTHENTICATION.execute_login:1987                %PROCESS_NATIVE.plsql:65

                        30%                                                                                                    101 1801726~          %AUTHENTICATION_API.login:57                      %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        :1                                                %PLUGIN.execute_process:2017

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform_process:188

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %PROCESS.perform:428

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              %.accept:6796

                                                                                                                                                                                                          :35

                      1.040 -8- update_user p_username=>nobody,p_workspace_user_id=>,p_authentication_result=>1,p_security      100 2047641~ nobody    %SESSION.update_user:965                          %PROCESS_NATIVE.plsql:65

                        31%    _group_id=>1801726177862873,p_old_security_group_id=>1801726177862873,wwv_flow_security.g_      101 1801726~          %AUTHENTICATION.execute_login:1989                %PROCESS_NATIVE.execute_process:1083

                                instance=>2047641529119,wwv_flow.g_instance=>2047641529119                                                            %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      1.040 -8- set_user p_user=>nobody                                                                        100 2047641~ nobody    %SESSION_CONTEXT.set_user:55                      %DYNAMIC_EXEC.execute_plsql_code:889

                        33%                                                                                                    101 1801726~          %SESSION.update_user:1021                          %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHENTICATION.execute_login:1989                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                                                                          :35

                      1.041 -8- reset_cache p_save_state=>true                                                                  100 2047641~ nobody    %AUTHORIZATION.reset_cache:421                    %PROCESS_NATIVE.plsql:65

                        35%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1994                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017

                                                                                                                                                        :1                                                %PROCESS.perform_process:188

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %PROCESS.perform:428

                                                                                                                                                        SYS.WWV_DBMS_SQL.run_block5:1033                  %.accept:6796

                                                                                                                                                        %DYNAMIC_EXEC.execute_plsql_code:889              :35

                      1.041 -9- check session integrity: security group id matches                                              100 2047641~ nobody    %SESSION.can_be_used:154                          SYS.WWV_DBMS_SQL.run_block5:1033

                        36%                                                                                                    101 1801726~          %SESSION.do_check_integrity:196                    %DYNAMIC_EXEC.execute_plsql_code:889

                                                                                                                                                        %SESSION.check_integrity:303                      %PROCESS_NATIVE.plsql:65

                                                                                                                                                        %AUTHORIZATION.reset_cache:425                    %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION.execute_login:1994                %PLUGIN.execute_process:2017

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PROCESS.perform_process:188

                                                                                                                                                        :1                                                %PROCESS.perform:428

                                                                                                                                                        SYS.DBMS_SYS_SQL.execute:2107                      %.accept:6796

                                                                                                                                                                                                          :35

                      1.041 -9- ...0 session cache rows deleted                                                                100 2047641~ nobody    %AUTHORIZATION.reset_cache:433                    %PROCESS_NATIVE.plsql:65

                        38%                                                                                                    101 1801726~          %AUTHENTICATION.execute_login:1994                %PROCESS_NATIVE.execute_process:1083

                                                                                                                                                        %AUTHENTICATION_API.login:57                      %PLUGIN.execute_process:2017