View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
17123 | Development | Other | public | 2021-02-23 15:13 | 2021-02-24 18:00 |
Reporter | ollehar | Assigned To | |||
Priority | none | Severity | minor | ||
Status | new | Resolution | open | ||
Summary | 17123: Store state of encrypted fields for archived tables | ||||
Description | When archiving/restoring a response/participant table using encryption, we need to know which fields were encrypted. Data will be stored in a new table with the following structure:; id - autoincrement integer Things to pay attention:
| ||||
Tags | encryption | ||||
Currently : when we export : we export decrypted, We don't offer (on 4.4 lats time i look) a way to export crypted. If we offer to export crypted : we need a real key management |
|
This is not for export/import, but for active/deactive survey, and to remember which questions was encrypted. You can change encryption settings between survey activation. It's a bit messy, indeed. |
|
Argl … |
|
« You can change encryption settings at all time» :D |
|
No no, only when survey is not activated. |
|
Column for sid would be nice. I also vote for a user_id (I just know that I will want to know that at some time or other (customer messes up entire survey, we can see exactly when it happened and who did it)). tblname - Can we do tbl_name or table_name? We use underscore in the database generally. |
|
tblname : why not only extraname part (the datetime) ? and add sid ? Unsure about time (and currently not crypted) but Then table name are always |
|
And when survey is deleted too (this one is most easy) |
|
NB: Who should have permission to deactive survey, disable encryption, then activate survey and importing old response table, now saved as clear text? |
|
Updated table schema and details @shnoulle: No, don't delete archived tables on survey deletion. I might want to load the data into a new copy with the same survey id. |
|
We don't delete it currently ? If not : maybe we need an option ? |
|
Oh, you broke previous system ? Currently : any admin with response (update/create?) can reload archived table (of current survey). |
|
Not breaking, more like fixing. If a survey is deleted and I create a survey with the same response ID I could probably access the data from the old response table, even if that data does not belong to me. |
|
We certainly do - but not right now. |
|
Ok, currently only VV is available.
I really think it's hard since gid and qid are updated … how do you know this qid is the same than this other qid ? |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2021-02-23 15:13 | ollehar | New Issue | |
2021-02-23 15:13 | ollehar | Description Updated | View Revisions |
2021-02-23 15:16 | ollehar | Description Updated | View Revisions |
2021-02-23 15:18 | DenisChenu | Note Added: 62463 | |
2021-02-23 15:19 | ollehar | Note Added: 62464 | |
2021-02-23 15:24 | c_schmitz | Description Updated | View Revisions |
2021-02-23 15:25 | c_schmitz | Description Updated | View Revisions |
2021-02-23 15:26 | c_schmitz | Summary | Store history of encrypted fields => Store state of encrypted fields for archived tables |
2021-02-23 16:39 | c_schmitz | Description Updated | View Revisions |
2021-02-23 16:57 | DenisChenu | Note Added: 62467 | |
2021-02-23 16:57 | DenisChenu | Note Added: 62468 | |
2021-02-23 17:54 | ollehar | Note Added: 62472 | |
2021-02-23 17:58 | ollehar | Note Added: 62473 | |
2021-02-23 18:27 | ollehar | Tag Attached: encryption | |
2021-02-24 07:13 | DenisChenu | Note Added: 62476 | |
2021-02-24 07:13 | DenisChenu | Note Edited: 62476 | View Revisions |
2021-02-24 07:14 | DenisChenu | Note Added: 62477 | |
2021-02-24 11:50 | ollehar | Note Added: 62485 | |
2021-02-24 16:28 | c_schmitz | Description Updated | View Revisions |
2021-02-24 16:30 | c_schmitz | Note Added: 62497 | |
2021-02-24 16:31 | c_schmitz | Description Updated | View Revisions |
2021-02-24 16:32 | c_schmitz | Note Edited: 62497 | View Revisions |
2021-02-24 16:33 | c_schmitz | Description Updated | View Revisions |
2021-02-24 16:34 | c_schmitz | Description Updated | View Revisions |
2021-02-24 16:34 | c_schmitz | Description Updated | View Revisions |
2021-02-24 16:35 | c_schmitz | Description Updated | View Revisions |
2021-02-24 16:57 | DenisChenu | Note Added: 62500 | |
2021-02-24 16:59 | DenisChenu | Note Added: 62501 | |
2021-02-24 17:58 | c_schmitz | Note Added: 62503 | |
2021-02-24 17:59 | c_schmitz | Note Added: 62504 | |
2021-02-24 18:00 | DenisChenu | Note Added: 62505 |