One of our users is suddenly not able to save views.
They can right click Views and click New View, add tables and the rest of the steps to build the view. When they go to Save View, it comes up with the following message in the screenshot.
I have looked up this error message and it talks about permissions that have been changed to the database.
I noticed that there is a CREATE VIEW permission which is set for this user under the database.
I even went as far as creating a Login for the server under Security > Logins, which I linked to a Windows Authenticated account. This Login has been added to the database and has the role of db_owner which the user having the issue and I are in, which has grant permissions for everything from the looks of things.
Strangely, the user can create views by executing the code directly, using:
create view <view_name> as <select statement>
Does anyone know what the issue is here?