Which command retrieves results for all objects of the row access policy db1.policies.objectslist at the database level?
db1.policies.objectslist
The INFORMATION_SCHEMA.POLICY_REFERENCES table function supports row access policies with the POLICY_NAME argument and returns a row for each object to which that policy is assigned. The REF_ENTITY_NAME and REF_ENTITY_DOMAIN arguments instead retrieve policies associated with a specified object. Snowflake POLICY_REFERENCES documentation
INFORMATION_SCHEMA.POLICY_REFERENCES
POLICY_NAME
REF_ENTITY_NAME
REF_ENTITY_DOMAIN
Community Discussion