Re: Logins, Users, Roles, Schemas

Perhaps these resources will help you.

http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Audrey Ng" <odd26uk@xxxxxxxxxxx> wrote in message
news:egfRrmTzGHA.4580@xxxxxxxxxxxxxxxxxxxxxxx
Hi everyone,

I have just migrating my database From SQL2K to SQL2005. Users, Roles
and Schemas were all migrated. No issues there. Logins, on the other
hand, did not get migrated. Thus, I believe making Users, Roles, Schemas
orphans, correct?

If I re-create the login and assigning the login to the database, it
will give an error saying that the user already exists. So, I delete the
User, then it prompts me that I have a schema associated with it, so I
delete the schema, then create the user. Roles have not been touched.
Must I also update the roles? and I'm not sure what schemas are in
comparison to SQL 2000.

Please advise of a better way to deal with users, logins, roles and
schemas.

Thanks,

Audrey



*** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Re: Logins, Users, Roles, Schemas
    ... However, if they 'own' any objects, the deletion will fail. ... How do you delete these from a database? ... the logins from the database? ... Thus, I believe making Users, Roles, Schemas ...
    (microsoft.public.sqlserver.security)
  • Re: Logins, Users, Roles, Schemas
    ... How do you delete these from a database? ... the logins from the database? ... Passwords Between SQL Servers ... Thus, I believe making Users, Roles, Schemas ...
    (microsoft.public.sqlserver.security)
  • Re: Logins, Users, Roles, Schemas
    ... Do sp_change_users_login 'report' to get a list of orphans before you decide ... How do you delete these from a database? ... the logins from the database? ... Thus, I believe making Users, Roles, Schemas ...
    (microsoft.public.sqlserver.security)
  • Re: Logins, Users, Roles, Schemas
    ... orphaned users. ... How do you delete these from a database? ... the logins from the database? ... and Schemas were all migrated. ...
    (microsoft.public.sqlserver.security)
  • Logins, Users, Roles, Schemas
    ... I have just migrating my database From SQL2K to SQL2005. ... Logins, on the other ... Thus, I believe making Users, Roles, Schemas ...
    (microsoft.public.sqlserver.security)
Quantcast