あるプロジェクトに新しいデータエンジニアリングチームが配属されました。チームは、既存のテーブルを確認するためにデータベースの顧客にアクセスする必要があります。チームには独自のグループチームがあります。
新しいチームにデータベース全体に対する必要な権限を付与するには、次のコマンドのどれを使用できますか?
正解:E
The correct command to grant the necessary permission on the entire database to the new team is to use the GRANT USAGE command. The GRANT USAGE command grants the principal the ability to access the securable object, such as a database, schema, or table. In this case, the securable object is the database customers, and the principal is the group team. By granting usage on the database, the team will be able to see what tables already exist in the database. Option E is the only option that uses the correct syntax and the correct privilege type for this scenario. Option A uses the wrong privilege type (VIEW) and the wrong securable object (CATALOG). Option B uses the wrong privilege type (CREATE), which would allow the team to create new tables in the database, but not necessarily see the existing ones. Option C uses the wrong securable object (CATALOG) and the wrong principal (customers). Option D uses the wrong securable object (team) and the wrong principal (customers). Reference: GRANT, Privilege types, Securable objects, Principals