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.
Diese Übung ist Teil des Kurses
Introduction to Redshift
Anleitung zur Übung
- Select the
polnameaspolicy_name,polattsascolumn_details, andpolqualascondition. - From the system row level security policy view.
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Select the policy name
SELECT ___ AS policy_name,
-- Select the column details
polatts AS ___,
-- Select the policy condition
___ as ___
-- FROM the system row level security policy view
FROM ___;