Hello, I created a new login and then created a new user [COM] in DB with default schema pointing to [COM] I created then schema [COM] WITH AUTHORIZATION [COM] I want this [COM] user to have all permissions it needs on [COM] schema only. How do I do that? When I try to create table [Com].Table it gives me permission denied. What am I missing?

• Changed type Casey KarstMicrosoft employee, Moderator Wednesday, May 20, 2015 5:48 PM Asking a question

Yes, that is correct.

You can have a look at this article which gives an high level overview of the permission management. It describes the differences between object and statement permissions.

Jan

• Proposed as answer by Silvia Doomra [MSFT]Microsoft employee Thursday, May 21, 2015 4:43 PM
• Marked as answer by artisticcheese Thursday, May 21, 2015 4:44 PM