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::Setting Validate_Password componet for MySQL Database to ensure password policy settings

Inadequate Password Settings for MySQL Database We observed that the `validate_password%` settings on hostname `<insert hostname>` a...