Skip to Main Content
  • Questions

  • how to know if a PDF is digitally signed

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, jesu.

Asked: July 03, 2024 - 9:01 am UTC

Last updated: July 04, 2024 - 6:39 am UTC

Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

Viewed 1000+ times

You Asked

Hello. I have an application in which users upload PDFs to a table. How can I check in PL/SQL if a PDF in a blob is digitally signed?
Ideally I'd like to know if the signature is valid, but just knowing if a file is not signed would be enough to reject it and save manual work.

Thanks

and Connor said...

I don't think we have anything natively in the database that can do that.

I've seen suggestions on some forums that a signed PDF will have the tag "/Sigflags" in the PDF, so you could look for that using DBMS_LOB.INSTR, but I can't vouch for the validity of that.



Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here