Search notes:

DBMS_CREDENTIAL.CREATE_CREDENTIAL

dbms_credential.create_credential creates a credential object.
dbms_credential.create_credential(
   credential_name       => '…'    ,   --  varchar2  
   username              => '…'    ,   --  varchar2  
   password              => '…'    ,   --  varchar2  
   database_role         => '…'    ,   --  varchar2   default
   windows_domain        => '…'    ,   --  varchar2   default
   comments              => '…'    ,   --  varchar2   default
   enabled               =>  …     ,   --  boolean    default
   key                   => '…'        --  varchar2   default
);

Create username/password pair

begin
  dbms_credential.create_credential(
      credential_name => 'RENES_CREDENTIALS',
      username        => 'rene',
      password        => '…'
  );
end;
/
select *
from
   dba_scheduler_credentials
where
   credential_name = 'RENES_CREDENTIALS';
select * from sys.scheduler$_credential;
begin
   dbms_credential.drop_credential('RENES_CREDENTIALS');
end;
/

See also

dbms_credential.create_credential is the favored alternative for the deprecated dbms_scheduler.create_credential.
The init parameter pdb_os_credential
dbms_credential

Index