How can a row access policy be applied to a table or a view? (Choose two.)
How can a row access policy be applied to a table or a view? (Choose two.)
A row access policy can be applied to a table or a view using a create table or create view DDL (Data Definition Language). This allows for the policy to be included at the time the table or view is created. Additionally, it can be applied to an existing table or view using the ALTER command, specifically by using ALTER [object] ADD ROW ACCESS POLICY [policy]. This command modifies the existing table or view to include the specified row access policy.
B, E https://docs.snowflake.com/en/user-guide/security-row-intro.html#apply-a-row-access-policy-to-a-table-or-view
B,E Correct. A is not correct as it is only defining not applying to table or view, Question is about applying to table/View https://docs.snowflake.com/en/user-guide/security-row-intro
Create / Alter Table/View DDL with row access policy
A. Within the policy DDL - CREATE TABLE t .. WITH ROW ACCESS POLICY p ON (c); E. Using the command ALTER TABLE t ADD ROW ACCESS POLICY p ON (c);
that is option B and E ryt
B and E are correct
BE are correct
Table level is the key
Correct
A & E are the correct choices