Difference between revisions of "SET ENCRYPTION"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) (→Products) |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Specify the default encryption key to be used when an encrypted table is accessed | Specify the default encryption key to be used when an encrypted table is accessed | ||
| Line 12: | Line 5: | ||
==Syntax== | ==Syntax== | ||
SET ENCRYPTION TO [<expC>] | SET ENCRYPTION TO [<expC>] | ||
| + | |||
SET ENCRYPTION ON | OFF | (<expL>) | SET ENCRYPTION ON | OFF | (<expL>) | ||
==See Also== | ==See Also== | ||
| − | APPEND FROM, COPY | + | [[APPEND FROM]], [[COPY]], [[COPY FILE]], [[COPY STRUCTURE]], [[DECRYPT]], [[DIR]], [[ENCRYPT]], [[USE]] |
| Line 30: | Line 24: | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
encrypt table1 key "key_1,key_2,key_3" | encrypt table1 key "key_1,key_2,key_3" | ||
encrypt table2 key "key_2,key_3,key_4" | encrypt table2 key "key_2,key_3,key_4" | ||
| Line 38: | Line 32: | ||
set encryption to | set encryption to | ||
use table1 encryption "key_1,key_2,key_3" | use table1 encryption "key_1,key_2,key_3" | ||
| − | use table2<key_2,key_3,key_4></ | + | use table2<key_2,key_3,key_4> |
| + | </code> | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| − | [[Category:Set_Commands]] | + | [[Category:Set_Commands|ENCRYPTION]] |
| + | [[Category:DES3 Encryption]] | ||
| + | [[Category:DES3 Encryption Set Commands]] | ||
Latest revision as of 15:46, 23 November 2009
Purpose
Specify the default encryption key to be used when an encrypted table is accessed
Syntax
SET ENCRYPTION TO [<expC>]
SET ENCRYPTION ON | OFF | (<expL>)
See Also
APPEND FROM, COPY, COPY FILE, COPY STRUCTURE, DECRYPT, DIR, ENCRYPT, USE
Description
If a database table is encrypted, the correct three-part encryption key must be specified before the table’s data or structure can be accessed. The SET ENCRYPTION TO set command can be used to specify a default encryption key to be used whenever an encrypted table is accessed without the key being specified. The <expC> is the three part comma-separated key.
If the command to access the table includes the key, either by appending it to the table filename specification or using an explicit clause, this will take precedence over the key defined by SET ENCRYPTION TO.
Issuing SET ENCRYPTION TO without the <expC> causes any previous setting to be cleared. The key must then be specified for each individual encrypted table.
The default key defined by SET ENCRYPTION TO <expC> is only active when SET ENCRYPTION is ON. SET ENCRYPTION OFF can be used to temporarily disable the default key. The SET ENCRYPTION ON | OFF setting does not change the default key itself. SET ENCRYPTION is ON by default.
Example
encrypt table1 key "key_1,key_2,key_3" encrypt table2 key "key_2,key_3,key_4" set encryption to "key_1,key_2,key_3" use table1 use table2<key_2,key_3,key_4> set encryption to use table1 encryption "key_1,key_2,key_3" use table2<key_2,key_3,key_4>
Products
Recital Server, Recital
