SQL permission issue???

[bloomlight]

I have an user who is having the permission to access the database and run query reports. Everything seems working just fine. But when she is trying to drop view or create view, she gets the following erroe message:

"Msg 3701, Level 14, State 20, Line 1
Cannot drop the view 'Hospice_LOS', because it does not exist or you do not have permission."

Any idea how to fix this?

Thanks.

 

[gmmastros]

What version of SQL Server are you using?

What permissions should this user have? Specifically, should this user have full access to the database, or do you want to restrict the permissions to just droping and creating views?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bloomlight]

SQL 2005 server.

She just needs to be able to run query reports. And be able to "drop view" or "create view" if needed.

 

[gmmastros]

Try this:

GRANT ALTER ON SCHEMA::dbo To <Login Name Here>

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom