Skip to main content

REVOKE PRIVILEGE

Description​

Revoke a privilege on a specified data object.

Syntax​

REVOKE PRIVILEGE <privilege> ON <object_type> <object_name> FROM <principal_type> <principal_identifier>

Examples​

REVOKE PRIVILEGE SELECT ON LAKE 'ilake' FROM GROUP 'eng_team'

Required parameters​

  • privilege: Specify one of {ALL_PRIVILEGES|DESCRIBE|CREATE|SELECT|INSERT|UPDATE|DELETE|ALTER|DROP}.
  • object_type: Specify one of {LAKE|DATABASE|TABLE}.
  • object_name: Specify the name of the object to revoke the privilege on.
  • principal_type: Specify one of {USER|GROUP|SERVICE_PRINCIPAL}.
  • principal_identifier: Specify one of {<user_email>|<group_id>|<service_principal_id>}.