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
.