remove access password via sql command

[antoniofalconx11426]

how do i remove or turn off "access password" on all files using an sql command?

google chrome decided to autofill and enable the access password while uploading a large quantity of file. I dont want to go back and click on everyone and "edit file" to remove the password. way too many.

 

[adam]

This should do it:

UPDATE file SET accessPassword = NULL;

 

[antoniofalconx11426]

thank you, much apprciated