How can a row access policy be applied to a table or a view? (Choose two.)

The correct answer is A. Within the policy DDL E. Using the command ALTER <object> ADD ROW ACCESS POLICY <policy>. A row access policy can be applied to a table or a view within the policy DDL when defining the policy. Additionally, an existing row access policy can be applied to a table or a view using the ALTER <object> ADD ROW ACCESS POLICY <policy> command.

Data Governance

Question

Options

AWithin the policy DDL
BWithin the create table or create view DDL
CBy future APPLY for all objects in a schema
DWithin a control table
EUsing the command ALTER <object> ADD ROW ACCESS POLICY <policy>;

How the community answered

(41 responses)

A
88% (36)
B
7% (3)
C
2% (1)
D
2% (1)

Explanation

A row access policy can be applied to a table or a view within the policy DDL when defining the policy. Additionally, an existing row access policy can be applied to a table or a view using the ALTER <object> ADD ROW ACCESS POLICY <policy> command.

Topics

#Row Access Policy#Data Governance#Row-Level Security#DDL Syntax

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice