search

crtsh / certwatch_db

Database schema
https://crt.sh/
GNU General Public License v3.0
194 stars 36 forks source link

ERROR: permission denied for relation certificate_lifecycle #64

Closed RufusJWB closed 5 years ago

RufusJWB commented 5 years ago

Suddenly i receive the error

ERROR: permission denied for relation certificate_lifecycle SQL state: 42501

when trying to execute the following statement

SELECT * FROM public.certificate_lifecycle WHERE ca_id = 52410.

Do you have any idea what happened?

robstradling commented 5 years ago

Hi @RufusJWB. I'm not sure what happened.

I've just dropped and re-created this VIEW (and run GRANT SELECT ON certificate_lifecycle TO GUEST). That seems to have done the trick.