Test: as admin, create a new user named "student" in site administration > users > add a new user as admin, create a new course and enrol "student" in this course as admin, create a new assignment activity in this course login as "student" and submit the file " sample.txt " in assignment activity check in your database that the file is present in "files" table SELECT contenthash, component, filename FROM mdl_files WHERE contenthash = 'b488e0740c94d4811e29350222f3bf2373d1b214' and component = 'assignsubmission_file' ; login as admin and delete "student" in site administration > users > browse list of users execute again this SQL query: SELECT contenthash, component, filename FROM mdl_files WHERE contenthash = 'b488e0740c94d4811e29350222f3bf2373d1b214' and component = 'assignsubmission_file' ;   Current result: The SQL query still returns a record.   Expected result: The SQL query should returns an empty result.