Closed. This question does not meet Stack Overflow guidelines . It is not currently accepting answers.

This question does not appear to be about programming within the scope defined in the help center .

Closed 2 days ago.
Improve this question

I have a user in a SQL Server 2016 database that is granted access via AD groups. When I run xp_logininfo 'ProblemUser' , ALL it shows the user is getting access from Domain\Dev-DB-R and Domain\Dev-DB-RW groups.

Dev-DB-R group is assigned db_datareader
Dev-DB-RW group is assigned db_datareader, db_datawriter, and db_owner

When ProblemUser attempts to run an ALTER on a view, they get the view couldn't be found because it doesn't exist or you don't have permission error.

Shouldn't the user be able to do pretty much anything with db_owner role assigned?

I have tried removing both group users from the database and the Server, then re-adding them to the server and database and assigning roles back in.