Some cards showing "You do not have permissions to run this query."

Hi @sanabasharat
There has been a lot of permission fixes since 0.41.4 - you should consider upgrading: https://github.com/metabase/metabase/releases/latest
The error indicates that it's a Data permission issue, not Collection permission issue.
Post the full stacktrace error from Admin > Troubleshooting > Logs.