1.

How To Resolve The Orphan Use Problem?

Answer»

To find out the ORPHAN USERS:

USE <database_name>;

GO;

sp_change_users_login @Action='Report';

GO;

To resolve the orphan USER PROBLEM:

10USE <database_name>;

GO

sp_change_users_login @Action='update_one', 

@UserNamePattern='<database_user>',

@LoginName='<login_name>';

GO

To find out the orphan users:

USE <database_name>;

GO;

sp_change_users_login @Action='Report';

GO;

To resolve the orphan user problem:

10USE <database_name>;

GO

sp_change_users_login @Action='update_one', 

@UserNamePattern='<database_user>',

@LoginName='<login_name>';

GO


Discussion

No Comment Found

Related InterviewSolutions