December 14, 2005 at 11:46 am
Greetings, We are running SQLServer V5 on Windows 2000. In our database all views with the exception of one are owned by dbo. The one in question is owned by a user, not dbo, and is of type user as are most of the dbo owned views. When an attempt is made to update this view a permissions error is displayed. I am new to SQLServer and am looking for some suggestions as to how to track down the problem. Do I need to change the ownership to dbo and if so how do I do that? Thanks.
December 14, 2005 at 12:22 pm
sp_changeobjectowner
A.J.
DBA with an attitude
December 14, 2005 at 12:53 pm
Greetings, I am logged on to the server, I bring up the query analyzer and execute the command exec sp_changeobjectowner 'view_name', 'dbo'; and receive the following message...
Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line 38
Object 'vwReportCustom' does not exist or is not a valid object for this operation.
I also tried it connecting as the sa user and still the message is the same. Assistance is appreciated. Thanks.
December 14, 2005 at 1:52 pm
rather than.. exec sp_changeobjectowner 'view_name', 'dbo'
try... exec sp_changeobjectowner 'user.view_name', 'dbo'
A.J.
DBA with an attitude
December 14, 2005 at 3:20 pm
That worked, thank you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply