When using Teradata Secure Zones, revokes zone access from zone guests. Zone guests are users or roles that do not belong to the zone but have previously been granted zone access.
Required Privileges
Only the creator of the zone can revoke zone access from a zone guest.
Syntax
REVOKE ZONE zone_name [...] { TO | FROM } { { user_name | role_name } [,...] | PUBLIC } [;]
Syntax Elements
- zone_name
- The name of the zone.
- user_name
- role_name
- The names of the zone guests that you want to revoke zone access from. You can specify up to 25 names in a comma-separated list.
Example of Revoking Zone Privileges
This example revokes the privileges from a zone guest named guest_jim01.
REVOKE ZONE widgets_inc_zone FROM guest_jim01 ;