Sunday, April 24, 2011

What do u means by orphan users, how u will list them in the DB?



Orphan User: NO login id or password is not associated
With user.

exec sp_change_users_login 'Report' (It helps to find the
orphan user)

Exec sp_change_user_login 'auto_fix','loginname',null(It
helps to map the user with login) 

exec sp_change_users_login 'Report' 

Running the following query on destination server where 
database as been moved to list orphan user

No comments:

Post a Comment

MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables

  Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...