When using Teradata Secure Zones, revokes the privilege to bypass zone restrictions when accessing rows in DBC tables.
Required Privileges
Only user DBC can revoke the ZONE OVERRIDE privilege.
Syntax
REVOKE ZONE OVERRIDE { TO | FROM } user_name [,...] [;]
Syntax Elements
- user_name
- The names of the users whose access to DBC table data that pertain to all zones you want to revoke. You can specify up to 25 comma-separated names.
Example of Revoking the ZONE OVERRIDE Privilege
This example revokes the ZONE OVERRIDE privilege from a user named Amy_F39674.
REVOKE ZONE OVERRIDE FROM Amy_F39674 ;