Skip to main content
Question

Exporting access policy

  • April 27, 2021
  • 0 replies
  • 2 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