Can I shed permissions during a session?
If you use Roles to control access to your tables, you can set a "read-only" role after opening the database connection: 

set role read_only_role; 


Where this role has select access on the target tables. 

https://dev.mysql.com/doc/refman/8.0/en/set-role.html