1. Learn
  2. /
  3. Courses
  4. /
  5. Introduction to Redshift

Connected

Exercise

Checking for row-level security

Amelia wasn't blocked from seeing any columns in the table; perhaps she can't see some rows, and you decide to check for any row-level security that might be applied to the table via the system row level security policy view, SVV_RLS_POLICY.

Instructions

100 XP
  • Select the polname as policy_name, polatts as column_details, and polqual as condition.
  • From the system row level security policy view.