August 31, 2011 at 1:30 am
Hi
If i dropthe user from Sql Server , will i able to open , execute,edit , save as the Stored Procedures, Packages , views created by that user....
if not , what i have to do.
pls help ....
thanks ,
pratap
August 31, 2011 at 2:08 am
Pratap
Are there any objects named MyUser.ObjectName, where MyUser is the user you want to delete? If so, consider using sp_changeobjectowner.
John
August 31, 2011 at 2:20 am
thanks for your reply...
what would happen if i delete the user without changing the Owner of the objects ....
As DB adminstrator, can i execute,open , edit, save as the stored procedures,DTS packages,views even after droping the user without changing the owner....
Thanks ....
Pratap
August 31, 2011 at 3:33 am
Pratap
You may find that you can't drop a user if it already owns objects. But there's a good way of finding out - try it, preferably on a test server.
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply