Creating a Secure Zone
Ever thought of creating a parameter around database objects? The users defined in this parameter can only access data in tables/views that are also set in this parameter. This setting up of this parameter is known as Secure Zone. If you are from a multi-country organization and want to separate data by country, then this is for you.
This is typically accomplished by creating different database hierarchies, known as Zones, in a single Teradata database:
Getting ready
To step through this recipe, we will connect to the Teradata database instance and use Teradata Studio to execute the create profile
command. Secure Zone is only available from Teradata 15.11 onwards.
You should have admin rights to perform zone creation.
How to do it...
The following are the steps for creating a Secure Zone:
- Open Teradata Studio and connect to the Teradata system.
- Open the Administrator window.
- Scroll down to the Secure Zone option.
- Double-click or left-click to showSecure Zone. This will display...