Skip to main content

SHOW GRANTS

Description​

Shows all permissions granted on the specified resource or object.

Syntax​

SHOW GRANTS ON <entity_type> <entity__name>

Examples​

SHOW GRANTS ON CLUSTER 'my_cluster'

SHOW GRANTS ON TABLE 'lake1.db1.table1'

SHOW GRANTS ON DATABASE 'lake1.db1'

SHOW GRANTS ON LAKE 'lake1'

Required parameters​

  • <entity_type>: Specify one of {ACCOUNT|PROJECT|GROUP|SERVICE_PRINCIPAL|CLUSTER|JOB|SOURCE|CATALOG|STREAM_CAPTURE|LAKE|DATABASE|TABLE}
  • <entity_name>: Specify the name of the object or resource to describe.