DROP_ROW_ACCESS_POLICY_ON_EVENTS_VIEW¶

Note

Using row access policies on the default event table is an Enterprise Edition feature.

Deletes the specified row access policy bound to the EVENTS_VIEW.

The EVENTS_ADMIN role includes the USAGE privilege on this procedure.

Syntax¶

SNOWFLAKE.TELEMETRY.DROP_ROW_ACCESS_POLICY_ON_EVENTS_VIEW(
  <row_access_policy_reference>
)

Copy

Arguments¶

row_access_policy_reference: A reference to a row access policy object for the policy to drop.

Returns¶

On successful execution, the procedure returns a string indicating success. Otherwise, the procedure returns an error.

Usage notes¶

This stored procedure uses owner’s rights. For more details, see Understanding caller’s rights and owner’s rights stored procedures.

Examples¶

Code in the following example drops the ROW_ACCESS_POLICY policy bound to the EVENTS_VIEW:

CALL SNOWFLAKE.TELEMETRY.DROP_ROW_ACCESS_POLICY_ON_EVENTS_VIEW(
  SYSTEM$REFERENCE('ROW_ACCESS_POLICY', 'mydb.myschema.mypolicy', 'SESSION', 'APPLY')
);

Copy