Skip to main content
Question

Exporting access policy

  • Apr 27, 2021 1:00 PM UTC
  • 0 replies
  • 7 views

zadvovl

Hello experts,
I have a simple question: is there a way of exporting access policies similarly to how the tables, views, projections and other objects are exported using SELECT EXPORT_OBJECTS()?
If not, then at least is there a way of getting a full length access policy creation/alteration expression? When looking into "v_catalog.access_policy" I see only a trimmed version of the expression - it's not enough to recreate it.
Best regards,
Vlad