Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question
Can you past an example query, and the exact error generated? –  datagod Jan 21 at 13:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.