Create Views and Trigger

Views and triggers allow applications to interact with the encrypted data in a seamless fashion. When a view is created on a table, the base table is renamed and a view is created with the original name of the table. Additionally, unique triggers are created for inserts and updates.

Views and triggers are created as part of the data migration. Perform this operation only if the views and triggers were previously deleted.

To recreate views and triggers, a user must have the following permissions within the schema in which the table resides:

• Connect

• Create any view

• Drop any view

• Create any trigger

• Drop any trigger

To create views and triggers:

1. Log on to the CipherTrust Manager GUI.

2. Click Database Protection to open the application. The Databases screen displays the list of existing database connections, if any.

3. Click the desired database connection.

4. Click the Tables link.

5. On the Authorize Database screen, enter the Database Password to access the tables.

6. Under the Tables with Encrypted Columns section, click the table for which you want create views and triggers.

7. From the Table Actions drop-down list, select Create Views and Triggers. The Create Views and Triggers for table for < table name > wizard is displayed. Follow the steps to complete the setup.

   a. Add General Info

   b. Preview SQL

   c. Perform Operation

Add General Info

1. On the General Info screen, enter the following details:

   Field	Description
   New Table Name	New name for the original table.
   View Name	Name of the view that will access the encrypted data.
   Insert Trigger	Name of the insert trigger that will insert values in the original table.
   Update Trigger	Name of the update trigger that will update values in the original table.

2. Click Next.

Preview SQL

1. Preview the SQL code to be executed. This code can’t be edited. This SQL code will be executed on the database.

2. If you want to modify General Info details, click Edit and update the fields.

3. Click Next.

Perform Operation

The Perform Operation screen shows the progress of the operation. A message The views and triggers were successfully created. Close the window to return to the list is displayed on the screen. Click Close to exit the wizard.