Encryption
This section explains cellset file encription. You can choose to skip this section if you are not a professional programmer. It won’t affect your learning about the other contents of this Tutorial.
This section explains the access privileges of esProc cellset files.
6.5.1 File encryption
esProc provides ways of encrypting cellset files to protect them from unauthorized access or use. There are two levels of encryption:
Execution privilege: With this privilege, users can set parameters, execute a cellset, and view resulting cell values and cellset descriptions, but cannot modify them. With only the execution privilege, users can neither see strings in the cells nor any cellset variables.
Full control privilege: With this privilege, users have full access to the cellset file and can take any action.
Take the following cellset as an example:
|
|
A |
B |
|
1 |
Minimum Population |
500000 |
|
2 |
$(demo) select * from CITIES |
/Get data from table CITIES. |
|
3 |
$(demo) select STATEID, ABBR from STATES |
/Get data from table STATES. |
|
4 |
=A3.select@1(ABBR==state).STATEID |
/Find the STATEID of the given state. |
|
5 |
=A2.select(POPULATION>B1&& STATEID==A4) |
/Find the cities. |
|
6 |
return A5 |
|
In the above cellset, column B contains the comment-style information.
Click Tool>Cellset description to set the cellset description:
The cellset uses a parameter state:
Click Tool>Cellset password on the menu bar to set the password on the pop-up window:
To set the password, just enter it in the box. And re-enter the password below to confirm it.
After a password is set for a cellset, save the cellset and then close it. The next time when you try to open the cellset and edit it, you must enter the password correctly.
Executing an encrypted cellset file does not require the password. We can invoke the cellset file in another application or execute it in another cellset.
If we need to open the encrypted cellset file again, we need to enter the password correctly:
A warning information will pop up if we enter a wrong password. Just click “Close” to close it:
By entering the correct password, we can view or modify the code in the cellset, or change the password:
