Password protection for ZIP file (not The containing files)

[jdemovic]

Hi,
is It possible to improve package by adding some pwd protection function for ZIP file itself ? (no for containing files)
Regards
J

[yallie]

Hi,

I think that's possible, but I don't have time to implement it, sorry :)
If you'd be so kind to implement it yourself, I'll be happy to accept a PR.
Thanks!

[dstrack]

Hi J,
this functionality already exists! Have a look at the file/package as_zip3.sql. The package has a add1file procedure with a p_password argument.

Regard from Berlin
D. Strack

[jdemovic]

Hi D,
thanks for reply.
this functionality protects the files inside the ZIP file (I have it done this way). User cas see the content of the ZIP file (how many files are in the archive and the file names). It wouldn't be.
I need the protection for the ZIP file itself (for the zip folder) as I mention in my first post.
Regards
J

[dstrack]

Hi J,
if the result would suites you purpose, then you could produce a zip achieve with the as_zip library and then wrap the resulting unprotected zip with a call to the as_zip3.
Regards
D

[jdemovic]

Hi D,
thanks for the guide. It isn't that user frendly as i expeced (two times unzip) but I'll try to push It forward.
Thanks again.