What do u mean by orphan users, how will u list them in the
DB
- 2 Answers
- 5889 Views
- IBM, I also Faced
- E-Mail Answers
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 do I determine how many instances of sql server are installed on a computer?
what's the difference between delete table and truncate table commands? : Sql server database administration
What does truncate do?
What are the differences between char and nchar in ms sql server?
Do you know how to send email from database?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What is the syntax to execute the sys.dm_db_missing_index_details?
Can you insert NULL in unique column?
What is the fastest way to permanently delete a 1 million row table named customers?
How to drop an existing table with "drop table" statements in ms sql server?
can a table be moved to different filegroup? : Sql server administration
what are the different stages of Report Processing?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What does ss stand for sexually?
Difference between Inner vs outer joins?
