Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL permission issue???

Status
Not open for further replies.

bloomlight

IS-IT--Management
Jun 12, 2006
149
US
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.
 
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
 
SQL 2005 server.

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

Code:
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top