|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
The HIDE command hides the text of a program, so that you cannot display it using a DESCRIBE, EDIT, or OBJ statement. You can perform all other actions on the program, including executing, compiling, renaming, or exporting.
When you hide a program, you supply a seed expression, which Oracle OLAP uses to encode the program text. You can use this seed expression later using an UNHIDE statement to make the text visible.
Note:This command performs simple encoding. For information on using secure encryption and other security features in Oracle, see Oracle Database Security Guide.
HIDE prog-name seed-exp
The name of the program whose text you want to hide. Do not enclose the program name in quotes.
A single-line text expression to be used as a seed value when encoding of the program text. Do not specify
NA for this value.
Keep a record of this seed expression, so that you can use it later with an UNHIDE statement. The seed expression you specify in the UNHIDE statement must be byte-for-byte the same value as you used in this HIDE statement. Also, the seed expression is case-sensitive, so record uppercase and lowercase characters carefully.
Exporting and Importing with the Seed
When you export and import a hidden program, the text remains hidden in the analytic workspace in which it is imported. It retains the same seed expression for use with the UNHIDE command.