BaşlayınÜcretsiz Başlayın

Diagnose a missing USAGE privilege

Claro's compliance team has just brought on a new data analyst. Their team lead created a role called ANALYST_ROLE, granted it SELECT on the CORE.CREDIT_SCORES table, and assigned the role to the new hire.

When the analyst runs a simple SELECT query against the CREDIT_SCORES table, Snowflake returns an error: "Insufficient privileges to operate on schema 'CORE'.

What is the most likely reason the query is failing?

Bu egzersiz

Snowflake Management, Governance & Collaboration

kursunun bir parçasıdır
Kursu Görüntüle

Uygulamalı interaktif egzersiz

İnteraktif egzersizlerimizden biriyle teoriyi pratiğe dökün

Egzersizi başlat