SQLTeam.com | Weblogs | Forums

Cannot drop the view 'XXX' because it does not exist or you do not have permission

migration
access
sql2005
tsql
sql2014

#1

we have application in which user can delete a view and he will get permissions from the user(he is a sa) in our database.but the user is not able to delete the view and it is throwing an error view does not exist or do not have permissions

the user has owned schema 'xxx'

me migrated our server from 2005 to 2014.
it worked perfectly in 2005 not in 2014


#2

just to fix this issue, if you try to take the ownership to another admin user, and remove it, see if that works?


#3

Are you explicitly specifying the schema in the DROP VIEW statement? Potentially the default schema for the User is different between the 2005 and 2014 environments.


#4

Thank you stephan,
We are looking how we are specifying the schema