Interested to Buy Any Domain ? << Click Here >> for more details...
What do u mean by orphan users, how will u list them in the
DB
- 2 Answers
- 6665 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raghu_iteamic
exec sp_change_users_login 'Report'
Running the following query on destination server where
database as been moved to list orphan user
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Does group by sort data?
How can I create a new template for import ? : sql server management studio
What are the new features in sql server 2016?
What is the importance of three tier architecture?
where can you add custom error messages to sql server? : Sql server administration
How to connect sql server management studio express to sql server 2005 express?
What is the use of @@spid?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
what is raid? : Sql server database administration
Can you please explain the difference between function and stored procedure?
What are the types of containers in ssis?
What is primary key and example?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
