I have a Schema and a Database Role. An Active Directory member is added to the Database Role. I grant the Role Select permission on the Schema. Control permission is denied on this Schema.
However, when the AD user runs a query, they get 'SELECT permission denied... schema 'MySchema'' error.
Why is this? Thanks