Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Droping the user SQL Server 2000 Expand / Collapse
Author
Message
Posted Wednesday, August 31, 2011 1:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 14, 2011 4:25 AM
Points: 4, Visits: 19
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
Post #1167926
Posted Wednesday, August 31, 2011 2:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 5,430, Visits: 10,099
Pratap

Are there any objects named MyUser.ObjectName, where MyUser is the user you want to delete? If so, consider using sp_changeobjectowner.

John
Post #1167934
Posted Wednesday, August 31, 2011 2:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 14, 2011 4:25 AM
Points: 4, Visits: 19
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
Post #1167941
Posted Wednesday, August 31, 2011 3:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 5,430, Visits: 10,099
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
Post #1167961
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse