We have an intranet which is restricted by ip address access but the files and media are accessible but not the actual pages.
Unrestricted access is turned on each file asset is there a way to disable this on mass as we have several hundred files which would need modification.
You can't disable them all in one go as Matrix needs to move files around and delete public entries.
The quickest way would be to remove public read access to all the files using a normal permission change. When that finishes, do a DB query to change all the flags. Then apply public read access again.
I suggest contacting support if you can as that DB query would need figuring out and testing before running it in production.