This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
USE ROLE accountadmin; | |
CREATE ROLE IF NOT EXISTS aad_provisioner; | |
GRANT CREATE USER ON ACCOUNT TO ROLE aad_provisioner; | |
GRANT CREATE ROLE ON ACCOUNT TO ROLE aad_provisioner; | |
GRANT ROLE aad_provisioner TO ROLE accountadmin; | |
CREATE OR REPLACE SECURITY INTEGRATION aad_provisioning |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Create a replica of the primary database in the traget account | |
CREATE DATABASE AMADEUS_DYNAMIC_PRICING | |
AS REPLICA OF ORGANIZATION_CODE.ORGANIZATION_NAME.AMADEUS_DYNAMIC_PRICING; | |
-- Refresh a secondary database | |
ALTER DATABASE AMADEUS_DYNAMIC_PRICING REFRESH; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Modify an existing permanent database to serve as a primary database using following statement | |
ALTER DATABASE amadeus_dynamic_pricing ENABLE REPLICATION TO ACCOUNTS ORGANIZATION_CODE.ORGANIZATION_NAME IGNORE EDITION CHECK; |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.