21 lines
632 B
SQL
21 lines
632 B
SQL
-- ============================================================
|
|
-- Step 1: create the PostgreSQL credential.
|
|
-- Run only this statement after replacing <RDS_PASSWORD> in the
|
|
-- Worksheet. Never save the actual password in this file.
|
|
-- Redmine: #730
|
|
-- ============================================================
|
|
|
|
BEGIN
|
|
DBMS_CLOUD.CREATE_CREDENTIAL(
|
|
credential_name => 'HMM_RDS_PG_CRED',
|
|
username => 'postgres',
|
|
password => '<RDS_PASSWORD>'
|
|
);
|
|
END;
|
|
/
|
|
|
|
-- Passwords are never returned by ALL_CREDENTIALS.
|
|
SELECT credential_name, username
|
|
FROM all_credentials
|
|
WHERE credential_name = 'HMM_RDS_PG_CRED';
|