You are here

SQL Server - Disabled User Account Overrides AD Group Authorization!

Just a quick note on a scenario I ran into, and what I did to fix it:


  • 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. 


  • 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.

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
1 + 16 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer