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
- 6576 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 to get the definition of a stored procedure back?
Define clusters?
How secure is sql server database?
Can we do dml on views?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What are the kinds of subquery?
what is bit datatype? : Sql server database administration
What is the data type of time?
Is it possible to replicate data from sql server to oracle? : sql server replication
How to compare the top two records using sql?
What is the standby server?
Explain what is the function of sql server agent windows service?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is a virtual table in sql?
whats new about truncate in sql server 2008?
