You can configure Static Authentication to avoid login demands while accessing your pages.

1. Grant the execution right on your package to lydy.

GRANT EXECUTE ON TEST TO lydy;

2. Use account with XDBADMIN role to set your DAD for lydy static authentication (you don’t need specify the password)

BEGIN
      dbms_epg.set_dad_attribute(dad_name => 'olvoyage',attr_name => 'database-username', attr_value => 'LYDY');
      END
      /

Warning: respect username case.

3. lydy must authorize the embedded gateway to use her privileges to invoke procedures and access document tables through the DAD. As lydy:

BEGIN
      dbms_epg.authorize_dad('LYDY');
      END;
      /