page63
45
Add schema entitlements.
GRANT USAGE ON SCHEMA IDENTIFIER ( $tpc_owner_schema ) TO ROLE
IDENTIFIER ( $tpc_owner_role );
Add object entitlements, and note the inclusion of dynamic tables, which are
currently in public preview.
GRANT USAGE ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
GRANT MONITOR ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
GRANT MODIFY ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
GRANT CREATE TABLE ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
GRANT CREATE DYNAMIC TABLE ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
GRANT CREATE VIEW ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
GRANT CREATE SEQUENCE ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
GRANT CREATE FUNCTION ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
GRANT CREATE PROCEDURE ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
GRANT CREATE STREAM ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
GRANT CREATE MATERIALIZED VIEW ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
GRANT CREATE FILE FORMAT ON SCHEMA IDENTIFIER ( $tpc_owner_
schema ) TO ROLE IDENTIFIER ( $tpc_owner_role );
Before you can use the new
tpc_owner_role
, you must grant the role to yourself.
GRANT ROLE IDENTIFIER ( $tpc_owner_role ) TO USER <Your Name Here>;
ChapTer 3
The Query profiler