page245
332
All SQL statements within this section
must
be rerun for each new consumer where
bespoke object content is created.
Unentitled Objects
As the heading suggests, these objects are not entitled and can be passed straight
through to your share, bypassing the entitlement engine. Figure 9-8 illustrates how you
create and then share a new object called
v_region
.
Figure 9-8.
Unentitled object share
First, you set your execution context.
SET share_owner_role = 'share_owner_role';
SET tpc_database = 'tpc';
SET share_owner_schema = 'tpc.share_owner';
SET tpc_warehouse_XS = 'tpc_wh_xsmall';
USE ROLE IDENTIFIER ( $share_owner_role );
USE DATABASE IDENTIFIER ( $tpc_database );
USE SCHEMA IDENTIFIER ( $share_owner_schema );
USE WAREHOUSE IDENTIFIER ( $tpc_warehouse_xs );
Reference data is a common use case for passthrough objects; in this example you
will create a secure view.
Chapter 9
Client expeCtations