Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Working with database objects » Working with materialized views

 

Encrypt and decrypt materialized views

Materialized views can be encrypted for additional security. For example, if a materialized view contains data that was encrypted in the underlying table, you may want to encrypt the materialized view as well. Table encryption must already be enabled in the database to encrypt a materialized view. The encryption algorithm and key specified at database creation are used to encrypt the materialized view. To see the encryption settings in effect for your database, including whether table encryption is enabled, query the Encryption database property using the DB_PROPERTY function, as follows:

SELECT DB_PROPERTY( 'Encryption' );

As with table encryption, encrypting a materialized view can impact performance since the database server must decrypt data it retrieves from the view.

 To encrypt a materialized view (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority. as the owner of the view, or as a user with DBA authority.

  2. In the left pane, double-click Views.

  3. Right-click the materialized view and choose Properties.

  4. Click the Miscellaneous tab.

  5. Select the Materialized View Data Is Encrypted checkbox.

  6. Click OK.

 To encrypt a materialized view (SQL)
  1. Connect to the database as a user with DBA authority, or as owner of the materialized view.

  2. Execute an ALTER MATERIALIZED VIEW statement using the ENCRYPTED clause.

 To decrypt a materialized view (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority or as the owner of the view.

  2. In the left pane, double-click Views.

  3. Right-click the materialized view and choose Properties.

  4. Click the Miscellaneous tab.

  5. Clear the Materialized View Data Is Encrypted checkbox.

  6. Click OK.

 To decrypt a materialized view (SQL)
  1. Connect to the database as a user with DBA authority, or as owner of the materialized view.

  2. Execute an ALTER MATERIALIZED VIEW statement using the NOT ENCRYPTED clause.

 Example of encrypting a materialized view
 Example of decrypting a materialized view
 See also