page62
44
you may prefer to vary the entitlements granted to roles; this is a simple template
for you to later expand.
Then grant entitlements to the role called
tpc_owner_role
starting with database
entitlements.
GRANT IMPORTED PRIVILEGES ON DATABASE snowflake TO ROLE IDENTIFIER
( $tpc_owner_role );
GRANT USAGE ON DATABASE IDENTIFIER ( $tpc_database ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
Add warehouse entitlements.
GRANT USAGE ON WAREHOUSE IDENTIFIER ( $tpc_warehouse_XS ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
GRANT OPERATE ON WAREHOUSE IDENTIFIER ( $tpc_warehouse_XS ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
GRANT USAGE ON WAREHOUSE IDENTIFIER ( $tpc_warehouse_S ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
GRANT OPERATE ON WAREHOUSE IDENTIFIER ( $tpc_warehouse_S ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
GRANT USAGE ON WAREHOUSE IDENTIFIER ( $tpc_warehouse_M ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
GRANT OPERATE ON WAREHOUSE IDENTIFIER ( $tpc_warehouse_M ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
GRANT USAGE ON WAREHOUSE IDENTIFIER ( $tpc_warehouse_L ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
GRANT OPERATE ON WAREHOUSE IDENTIFIER ( $tpc_warehouse_L ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
GRANT USAGE ON WAREHOUSE IDENTIFIER ( $tpc_warehouse_XL ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
GRANT OPERATE ON WAREHOUSE IDENTIFIER ( $tpc_warehouse_XL ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
ChapTer 3
The Query profiler