seamless icon indicating copy to clipboard operation
seamless copied to clipboard

To document: fingertipping security risks

Open sjdv1982 opened this issue 1 year ago • 0 comments

Seamless databases are expected to be shared freely among the community.

It is needed to document the security risks of fingertipping from a malicious database.

Fingertipping from expression or structured cell join should be relatively safe. Expressions and structured cell joins may give malicious data, but not malicious code. An attack would have to be specifically against a code cell or schema cell that is synthesized before being executed. Even the header generated by the compiled transformer's gen_header is not automatically added to any code.

Fingertipping from transformation is another case. This obviously executes arbitrary code. Therefore, transformations are fingertip-mined from the rev_transformation table. By default, it contains just a reverse mapping of the transformation table, but the database will function fine if this is not the case. Therefore, it is the idea to curate rev_transformation as to allow only trusted transformations in it. merge-databases does not merge rev_transformation by default.

sjdv1982 avatar Nov 22 '23 09:11 sjdv1982