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
- 6715 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 |
What is inline table-value user-defined function?
What are the restrictions that views have to follow?
What is the architecture of ms sql reporting service?
What are number line correlation administrators will use while working with a subquery?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
How can we improve performance by using SQL Server profiler?
select top 5 * from emp order by newid() my question is , how this query get executed?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What are the commands used in DCL?
what is a stored procedure and trigger?
What is difference between sql and sql server?
What is normalization and what are the advantages of it?
-
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)
