SQL Server – Disabled User Account Overrides AD Group Authorization! Writer #1, 2016-12-28 Just a quick note on a scenario I ran into, and what I did to fix it: Scenario A user was running a stored procedure that created a table. Rather than having a table created in the "dbo" schema, it was creating a table with their user name as the schema, as in: DOMAIN\Username.TableName. The user was authorized via an AD group login. The user's individual user name was a disabled "User" in the database they were accessing. Fixing I specified the default schema to "dbo" in the AD account. I did this first and this alone did not fix the issue. The disabled user account's settings overrode this setting. Removed the objects in the database in their non-dbo schema. Removed schema (within the database, security, schema folder). Dropped the username Perhaps changing the default schema on the disabled account would have also helped, but I didn't try that. There are only so many hours in a day. SQL Server AD groupdboschemasecuritysql serveruser schema