1-- Step 1: Create the share
2CREATE SHARE sales_share;
3
4-- Step 2: Grant access to objects
5GRANT USAGE ON DATABASE sales_db TO SHARE sales_share;
6GRANT USAGE ON SCHEMA sales_db.public TO SHARE sales_share;
7GRANT SELECT ON TABLE sales_db.public.orders TO SHARE sales_share;
8GRANT SELECT ON TABLE sales_db.public.customers TO SHARE sales_share;
9
10-- Step 3: Add consumer accounts
11ALTER SHARE sales_share ADD ACCOUNTS = org1.consumer_acct;
12
13-- View shares
14SHOW SHARES;
15DESCRIBE SHARE sales_share;

1-- View available shares
2SHOW SHARES;
3
4-- Create a database from the share
5CREATE DATABASE shared_sales FROM SHARE provider_org.provider_acct.sales_share;
6
7-- Grant access to roles
8GRANT IMPORTED PRIVILEGES ON DATABASE shared_sales TO ROLE analyst_role;
9
10-- Query shared data (read-only)
11SELECT * FROM shared_sales.public.orders LIMIT 10;

1-- Create a secure view that filters data per consumer
2CREATE OR REPLACE SECURE VIEW sales_db.public.v_orders_shared AS
3SELECT order_id, order_date, product, amount
4FROM sales_db.public.orders
5WHERE region = CURRENT_ACCOUNT();  -- Row-level filtering
6
7-- Grant the secure view to the share
8GRANT SELECT ON VIEW sales_db.public.v_orders_shared TO SHARE sales_share;

1-- Create a managed (reader) account
2CREATE MANAGED ACCOUNT partner_reader
3ADMIN_NAME = 'partner_admin'
4ADMIN_PASSWORD = 'SecurePass123!'
5TYPE = READER;
6
7-- Add the reader account to the share
8ALTER SHARE sales_share ADD ACCOUNTS = partner_reader;