A few months ago, I have created a schema to secure a handful of views. I granted a SQL Authentication account to this schema. The objective is so this SQL account only has access to these views and nothing else in the database. This setup has been successful for many months.
Now, I was asked to move that schema to another database which I did. Unfortunately, it is saying the SQL account does not have permission to the tables in the original database. Keep in mind, I cannot grant this account "DB_Reader" for the security reason that it will be able to read all tables.
Am I missing something on granting in the Schema or the SQL account? It seems like it is at the SQL account level.