What do u mean by orphan users, how will u list them in the
DB
Answer Posted / karthik
Orphan User : NO login id or password are 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)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How can you insert values in multiple rows using one Insert statement?
How do you identify a foreign key?
What are advantages of ssrs or why we should use ssrs?
What is dknf in normalization form?
How do I find information about the install locations for the various instances running on a computer?
Explain transaction server distributed transaction?
What is resource db in sql server?
how we use window authentication connection with sql server.?
How to retrieve field values using mssql_result()?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is bit data type? What's the information that can be stored inside a bit column?
What are the different types of backups that exist?
How to achieve Paging of records in SQL SERVER?
What is data compression?
If user is owning any SQL Objects, can we drop that user