vvgsrk

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

vvgsrk

-- Lists the streams for which you have access privileges
SHOW STREAMS LIKE 'dp_logs_stream' IN ACCOUNT;

-- Describes the columns in a stream
DESCRIBE STREAM amadeus_dynamic_pricing.dynamic_pricing.dp_logs_stream;

-- Lists the stored procedures that you have privileges to access
SHOW PROCEDURES LIKE 'INSERT_DP_LOGS' IN ACCOUNT;

-- Lists the tasks for which you have access privileges

vvgsrk

-- 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;

vvgsrk

-- 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;

aparrish